Thread
:
Inefficient VBA Code - Worksheets Property
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Inefficient VBA Code - Worksheets Property
can't shorten as written. You can use goto and a referenceSub gothere()
Application.Goto reference:=[Sheet15!a2]
End Sub
But, if you want to get info or copy you don't have to select anyway. How
about more info on what you want to do .
--
Don Guillett
SalesAid Software
Granite Shoals, TX
"Aaron" wrote in message
...
Hi,
Is there a way to condense the VBA code listed below into
1 line:
Worksheets("Sheet3").Activate
Range("A3").Activate
What about
Worksheets("Sheet3").Activate
Range("A3").Select
I couldn't get what's listed below to work...
Sheets("Sheet3").Range("A3").Activate
Worksheets("Sheet3").Range("A3").Activate
Sheets("Sheet3").Range("A3").Select
Worksheets("Sheet3").Range("A3").Select
Thanks for any help you may be able to provide!
Aaron
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]