Hi folks!

Got something "tacky" going on and didn't care for the work-around ... am hoping someone knows a more eloquent solution!

Long story short ... from a macro invoked by clicking a button on sheet2, I wrote formulas on sheet3, copied them, and pastspecial ran them down to the end of a table I had put there with code.

When the user chooses sheet3, they have more than half the screen selected from that operation, so I used the sheet activate event to select cell A1. Tacky...

Sheets(3).range("A1").select or activate gives the titled error. So does creating worksheet objects and attempting the same on them (my syntax error?).

How do I change the selected cell on a different sheet using VBA code?

TIA

Grug