| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CELL Function in VBA ?
Sub mypathis()
'MsgBox ActiveWorkbook.Path 'MsgBox ActiveWorkbook.Name With ActiveWorkbook MsgBox .Path & "\" & .Name End With End Sub -- Don Guillett SalesAid Software "Jakobshavn Isbrae" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CELL Function in VBA ?
jake,
It doesn't look like Cell is a supported worksheet function. Try using a combination of ActiveWorkbook.FullName and Activesheet.Name hth, Doug "Jakobshavn Isbrae" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CELL Function in VBA ?
Don & Doug:
Thank you both very much. -- jake "Doug Glancy" wrote: jake, It doesn't look like Cell is a supported worksheet function. Try using a combination of ActiveWorkbook.FullName and Activesheet.Name hth, Doug "Jakobshavn Isbrae" wrote in message ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
