How to reference a cell address in VBA

  • Thread starter Thread starter Ivan
  • Start date Start date
I

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
 
Back
Top