When I use the offset method in Excel to select an adjacent cell it works fine.
I have pushed some data via MS Project to XL using code in Project. It seems when I use the Offset property it is not supported.
ActiveCell."Offset" does not appear in the object drop downs when coding in Project.
Any thoughts as to how I can deal with this? I want to push data to a new XL file so all the code has to reside in Project.
I have also selected the MS Excel Object library.
Thanks
I have pushed some data via MS Project to XL using code in Project. It seems when I use the Offset property it is not supported.
ActiveCell."Offset" does not appear in the object drop downs when coding in Project.
Any thoughts as to how I can deal with this? I want to push data to a new XL file so all the code has to reside in Project.
I have also selected the MS Excel Object library.
Thanks