Solved: Code Select Sheet & Range single step

[Victor]

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]

[vba]Application.Goto Worksheets("Sheet3").Range("A1:B20"), True[/vba]

Hope this helps,

Mark

[mdmackillop]

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
[VBA]Worksheets("Sheet3").Range("A1:B20").Interior.ColorIndex = 6
'or
Worksheets("Sheet3").Range("A1:B20").Copy Worksheets("Sheet1").Range("A1")[/VBA]