| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CELL Function in VBA ?
The formula
=CELL("filename",A1) gives me something like C:\Documents and Settings\Owner\Desktop\[Book1.xls]Sheet1 in VBA s = Application.WorksheetFunction.Cell("filename", A1) does nothing. How can I get the same string in VBA that CELL() gives me in the worksheet? Thanks in advance for any help or suggestions. -- jake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| Copy Excel Function from a Cell Through a Function | Excel Worksheet Functions | |||
| I want result of a function in the cell and not the function itsel | Excel Worksheet Functions | |||
| Can function in one cell change value or function in another cell? | Excel Worksheet Functions | |||
| Custom Function: Detecting the cell the function is used in | Excel Programming | |||
Threaded Mode
