I am trying to call the Excel CELL function using VBA from the workbook that is running the macro. I'm assuming I just have a syntax error, but I can't figure it out. I am using Excel 2013.
Please Login or Register to view this content.
I am trying to call the Excel CELL function using VBA from the workbook that is running the macro. I'm assuming I just have a syntax error, but I can't figure it out. I am using Excel 2013.
Please Login or Register to view this content.
There is absolutely no point to that. You can just use the FullName property of the relevant workbook in VBA.
Rory
Thanks Rorya! I will try that instead. However, just out of curiosity, why doesn't the above statement compile/run?
Because the WorksheetFunction object doesn't have a CELL method, for much the reason I suggested - i.e. there is no need for it.
Hi bvwalker,
Not all normal excel functions are supported using the VBA worksheetfunction method. I don't think "Cell" is supported. See:
https://support.microsoft.com/EN-US/help/213660
See a list of all the supported functions at:
https://docs.microsoft.com/en-us/off...ksheetFunction
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for the information MarvinP!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks