| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reference a cell address in VBA
I have the following formula in a cell:
=CELL("address",SheetWIP!$H$62) which generates the following result: [Skeleton_WIP.xls]SheetWIP!$H$62 I need to have a VBA line that keeps the current sheet active but can activate the cell next to the referenced cell and insert a value. I have tried the RANGE command and the OFFSET command but I haven't had much luck. How can I do this? Thanks, Ivan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to reference a cell address in VBA
Hi
try Activecell.offset(0,1).value = "your value" -- Regards Frank Kabel Frankfurt, Germany Ivan wrote: I have the following formula in a cell: =CELL("address",SheetWIP!$H$62) which generates the following result: [Skeleton_WIP.xls]SheetWIP!$H$62 I need to have a VBA line that keeps the current sheet active but can activate the cell next to the referenced cell and insert a value. I have tried the RANGE command and the OFFSET command but I haven't had much luck. How can I do this? Thanks, Ivan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to email to address in cell reference | Excel Discussion (Misc queries) | |||
| Get cell reference address | Excel Worksheet Functions | |||
| Cell address without absolute reference | Excel Worksheet Functions | |||
| How do I get the cell address of a VLOOKUP reference? | Excel Worksheet Functions | |||
| how to make cell address reference increment? | Excel Worksheet Functions | |||
Linear Mode
