Cell selection in non-active sheet

O

Otto Moehrbach

Excel 2002, WinXP
All the following relates to doing this in VBA.

If I paste something to say, A3:D3, then A3:D3 of that sheet is highlighted
in blue.

If I want to get rid of the blue highlight, and make A1 the active cell on
that sheet, and that sheet is the active sheet, all I have to do is select
A1.

Question: How can I make this happen when that sheet is not the active
sheet, short of selecting that sheet first?

Thanks for your help. Otto
 
K

keepITcool

I assume you want to copy paste
and not show what you'ce copied thrue the selection..

use syntax like
Range("sheet1!a3:d3").copy Range("sheet2!a4:d4")

and there's no need to (re)select any cells :)


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
Top