No announcements
Found 2109969 threads
-
0 VotesConverting Excel Formula to VBA code
Hi NYYFAN, For IF and OR function: If Range(“C8”).Value=”Work” Or Range(“C8”).Value=”Off” ...Answered | 1 Replies | 726 Views | Created by NYYFAN_NC - Wednesday, November 19, 2014 1:55 AM | Last reply by Starian chen - Thursday, November 20, 2014 9:28 AM
-
3 Votes
how to convert an EXCEL =FIND( ) formula to VBA in Excel 2010
Ah - you don't want to look at the cell values but at the formulas.Answered | 10 Replies | 23719 Views | Created by Jimbo213 - Friday, December 10, 2010 6:50 PM | Last reply by jmontani - Friday, September 6, 2013 2:09 PM -
0 Votes
VBA Code to Wrap Formula in an =IF()?
Try: myCell.Formula="=IF("& mid(myCell.Formula,2) &"=0,"""","& mid(myCell.Formula,2) &")" Rod ...Answered | 4 Replies | 770 Views | Created by JHHui - Tuesday, July 21, 2015 11:10 PM | Last reply by JHHui - Wednesday, July 22, 2015 4:31 PM -
5 Votes
How to insert formula in excel with vba, please!
WorksheetFunction executes an Excel worksheet function and returns its result.Answered | 4 Replies | 51434 Views | Created by Valentin Andreev - Tuesday, October 23, 2012 8:23 AM | Last reply by Hans Vogelaar MVP - Wednesday, June 13, 2018 8:23 PM -
0 Votes
Problem with convert an Excel formula to a PowerPivot formula
And in PowerPivot, you work with tables and columns instead of actual cell references in excel.Answered | 1 Replies | 4459 Views | Created by XeonCore - Thursday, November 22, 2012 12:12 PM | Last reply by Brent Greenwood - Thursday, November 22, 2012 2:30 PM -
4 Votes
Converting VBA code to VB
what differs from vba is that each code class starts with a class declaration and ends with an end class.Answered | 9 Replies | 3028 Views | Created by vgoli - Tuesday, February 9, 2010 4:24 AM | Last reply by vgoli - Wednesday, February 10, 2010 2:39 AM -
0 Votes
VBA for Excel 2010 - Help
@Moderator: this thread belongs in an Excel forum, not in a feedback forum.Answered | 1 Replies | 5923 Views | Created by ricostrydom - Wednesday, June 20, 2012 2:02 PM | Last reply by Hans Vogelaar MVP - Wednesday, June 20, 2012 10:02 PM -
0 Votes
Copying Formulas in a VBA macro
btw, this is Excels original way for expressing formulas :)Answered | 8 Replies | 69796 Views | Created by Vpp1253 - Thursday, September 17, 2015 3:56 PM | Last reply by Vpp1253 - Tuesday, September 22, 2015 3:21 PM -
0 Votes
Excel VBA remove everything between 2 characters in formula
>>Using vba code i want to remove everything between and including square brackets [ ].Answered | 2 Replies | 2423 Views | Created by zaveri cc - Wednesday, December 23, 2015 9:54 PM | Last reply by David_JunFeng - Thursday, December 24, 2015 3:25 AM -
0 Votes
Use Slicers's Selection in Formula or in VBA
Hi David, I've managed to amend the code and now it works!Answered | 4 Replies | 4128 Views | Created by Bond. James Bond - Thursday, August 25, 2016 9:47 PM | Last reply by Bond. James Bond - Friday, September 2, 2016 4:05 PM -
0 Votes
How to optimize this complex excel formula ?
The Article is optimizing the performance of Excel Formula in VBA.Answered | 1 Replies | 632 Views | Created by Balaramji - Wednesday, May 4, 2016 5:29 PM | Last reply by Deepak Saradkumar Panchal - Thursday, May 5, 2016 6:12 AM -
0 Votes
Looking for R code that is the equivelant of an Excel formula
I can make it work in Excel, but I am trying to do all the data prep steps in Azure ML/R.Answered | 5 Replies | 389 Views | Created by Priya Santhanam - Tuesday, December 6, 2016 11:02 PM | Last reply by jopela-msft - Friday, December 9, 2016 4:36 PM -
0 Votes
Add the formula to the formula bar in excel
Hi Helix, According to your description, you want to see the expression in the excel file after exporting to excel, right?Answered | 3 Replies | 1128 Views | Created by Helixpoint - Tuesday, September 1, 2015 5:41 PM | Last reply by 王者荣耀 - Wednesday, September 2, 2015 2:38 AM -
4 Votes
SQL Codes in VBA for Excel
I’m afraid that your topic about VBA is unsuitable here.Answered | 6 Replies | 6847 Views | Created by Michael Andrew Lee - Friday, January 6, 2012 5:19 AM | Last reply by danishani - Friday, January 27, 2012 10:19 PM -
0 Votes
Loop formula / VBA code that increments a cell value until match is achieved.
The following code example sets the formula for cell A1 on Sheet1.Answered | 3 Replies | 2907 Views | Created by Jason_Paul_Edwards - Sunday, February 8, 2015 8:46 AM | Last reply by Fei Xue - Friday, February 13, 2015 7:00 AM -
0 Votes
How to convert JSON String to VBA Object using Excel VBA
In Office 2010 I developed a VBA Macro which comunicates with a Web-Service.Answered | 1 Replies | 15673 Views | Created by Stephan_JHW - Sunday, September 23, 2012 7:10 PM | Last reply by Syswizard - Monday, September 24, 2012 12:39 PM -
0 Votes
Excel VBA Code to delete Empty ListObject Row
So I wrote VBA Code to automate deletion of Blank Row process.Answered | 3 Replies | 5423 Views | Created by nomen86 - Wednesday, October 28, 2015 1:33 AM | Last reply by James Cone - Wednesday, October 28, 2015 2:26 PM -
1 Votes
Excel formula - comparing a date to today()
That formula should work OK, eg applied with VBA over a contiguous range Range("K2:K5").Formula = "=IF(J2Answered | 1 Replies | 2778 Views | Created by Brian Hyam - Monday, February 6, 2012 4:19 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Monday, February 6, 2012 5:00 PM -
1 Votes
Excel VBA Replace Issue
Guess you use VBA Replace function.Answered | 2 Replies | 705 Views | Created by AGI_MEG - Wednesday, October 12, 2016 1:00 PM | Last reply by AGI_MEG - Tuesday, October 18, 2016 9:13 PM -
0 Votes
Excel formula
This is regarding your Excel formula: Year 5 Year 6 sublevels progress 2c 1a ...Answered | 2 Replies | 13557 Views | Created by juliedh - Monday, November 22, 2010 2:16 PM | Last reply by Luigi Bruno - Monday, December 19, 2011 3:29 PM - Items 1 to 20 of 2109969 Next ›
No announcements
