ActiveCell on inactive sheet
GS wrote:
Oops! Wrong again. I'm confusing Excel behavior with my ActiveX
spreadsheet component yet again! Sorry about that...
In Excel, ActiveCell is a member of Window and so must be the active
sheet to use ActiveCell as I suggested.
Yes, but excel somehow remembers what cell is (was) active on each sheet.
I thought that it is accessible.
Thanks anyway.
|