PDA

View Full Version : Solved: Code Select Sheet & Range single step



Victor
03-10-2009, 03:43 AM
Hi all:

I usually used:

Sheets("name").select
Range("name).select

Now I am trying to do it in a single step:

Sheets("name").range("name").select

But I still missing something to make it work.

Please let me know how to solve it.

Thanks for the help.

Victor

GTO
03-10-2009, 04:10 AM
Application.Goto Worksheets("Sheet3").Range("A1:B20"), True

Hope this helps,

Mark

mdmackillop
03-10-2009, 11:07 AM
Hi Victor,
Unless the Selection is the "end result", you should try to avoid selecting cells in macro code. Ranges can be manipulated without selection
eg
Worksheets("Sheet3").Range("A1:B20").Interior.ColorIndex = 6
'or
Worksheets("Sheet3").Range("A1:B20").Copy Worksheets("Sheet1").Range("A1")