I am having trouble selecting a cell on a different sheet. If Sheet1 is active and I need to select a cell on Sheet 2 i assumed that byqualifying the cell on Sheet 2 VBA would automatically go to thecell. Is this not correct?This does not work:Sub TryA1()Worksheets("Sheet1").Range("Q2").SelectWorkbooks("BOOK1").Worksheets("Sheet2").Range("A1").SelectEnd SubThis does work:Sub TryA2()Worksheets("Sheet1").Range("Q2").SelectWorksheets("Sheet2").ActivateWorksheets("Sheet2").Range("A1").SelectEnd SubIf the range address is qualified why is it necessary to activateSheet 2 first?
Probably because you're trying to select, as opposed to doingsomething else to it, such as copying to it or changing its format orchanging its value.
No idea of the "why", but you are correct.See alsomsdn.microsoft.com/.../xl\howSelectingandactivatingcells1_HV05204866.asp for Microsoft's words on thesubject.
Thank you for your reply and your research. This was very helpfuland helped me learn a lot.