How to reference a cell address in VBA

[Ivan]

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

 

[Frank Kabel]

Hi
try
Activecell.offset(0,1).value = "your value"