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

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