Re: Selecting range question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: ToddG (anonymous_at_discussions.microsoft.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 09:28:47 -0700

Hi Bernie,

Here is a simple example:

Sheets("TEST").Select
Range("A1:F129").Select
Selection.Sort Key1:=Range("F2"), _
Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, _
MatchCase:=False, _
Orientation:=xlTopToBottom

>-----Original Message-----
>Todd,
>
>You rarely ever need to select anything: post all your
code, and we can give
>you some pointers as to how to re-write without using
select.
>
>HTH,
>Bernie
>MS Excel MVP
>
>"ToddG" <anonymous@discussions.microsoft.com> wrote in
message
>news:1910501c44ca8$ebc9e3b0$a301280a@phx.gbl...
>> I have the following code to select a range:
>>
>> Sheets("TEST").Select
>> Range("A1:F129").Select
>>
>> Is there a way to select this range WITHOUT first
>> selecting the ***? I'd like to speed up my macro and
>> thought this would be a good place to start.
>>
>> I tried:
>>
>> Sheets("TEST").Range("A1:F129")
>>
>> and I get an error.
>>
>> TIA, Todd
>
>
>.
>

Quantcast