G
Guest
Guest
What is the command in a VB macro to get a spreadsheet opened on a specific cell in a specific sheet each time?
Andy
Andy
On 2002-02-27 19:36, NateO wrote:
I've seen it happen James, and vice versa, where you always want a sheet no matter where the location...Referencing worksheet #'s does get a little trickier when hidden sheets are involved (i.e., you think you're working with the 2nd sheet and it's really the third), but I'll save that for another post. Have a good one James.
Cheers, Nate
This message was edited by NateO on 2002-02-27 19:39
On 2002-02-27 20:11, Ivan F Moala wrote:
Works ALL the time no matter what you change the Tab name to.
Sub test()
Sheet1.Activate
End Sub