ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selecting range question (https://www.excelbanter.com/excel-programming/300643-selecting-range-question.html)

ToddG
Selecting range question
 
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 sheet? 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

Bernie Deitrick
Selecting range question
 
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" wrote in message
...
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 sheet? 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

Don Guillett[_4_]
Selecting range question
 
You probably don't need to select any but use
application.goto Sheets("TEST").Range("A1:F129")

--
Don Guillett
SalesAid Software

"ToddG" wrote in message
...
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 sheet? 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

ToddG
Selecting range question
 
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" wrote in
message
...
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 sheet? 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


.

Bernie Deitrick
Selecting range question
 
Todd,

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


HTH,
Bernie
MS Excel MVP

"ToddG" wrote in message
...
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" wrote in
message
...
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 sheet? 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


.

Don Guillett[_4_]
Selecting range question
 


--
Don Guillett
SalesAid Software

"ToddG" wrote in message
...
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" wrote in
message
...
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 sheet? 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


.

Don Guillett[_4_]
Selecting range question
 
try from ANYWHERE.
Sheets("TEST").Range("A1:F129").Sort Key1:=Range("F2"), _
Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, _
MatchCase:=False, _
Orientation:=xlTopToBottom


--
Don Guillett
SalesAid Software

"ToddG" wrote in message
...
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" wrote in
message
...
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 sheet? 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


.

Bernie Deitrick
Selecting range question
 
Todd,

Oops, forgot to fully qualify the key range:

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

HTH,
Bernie
MS Excel MVP

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Todd,

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


HTH,
Bernie
MS Excel MVP

"ToddG" wrote in message
...
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" wrote in
message
...
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 sheet? 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


.

Don Guillett[_4_]
Selecting range question
 
Should probably be (for sort key)

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


--
Don Guillett
SalesAid Software

"ToddG" wrote in message
...
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" wrote in
message
...
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 sheet? 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


.

Bernie Deitrick
Selecting range question
 
Don,

You forgot the same thing that I did: the key needs to be

Sheets("Test").Range("F2")

if Test is not the activesheet.

Bernie
MS Excel MVP

"Don Guillett" wrote in message
...
try from ANYWHERE.
Sheets("TEST").Range("A1:F129").Sort Key1:=Range("F2"), _
Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, _
MatchCase:=False, _
Orientation:=xlTopToBottom


--
Don Guillett
SalesAid Software

"ToddG" wrote in message
...
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" wrote in
message
...
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 sheet? 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


.

ToddG
Selecting range question
 
That did it...thanks to you both


-----Original Message-----
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 sheet? 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
.

Don Guillett[_4_]
Selecting range question
 
I know. I caught it as just after I touched the send button. Thanks

--
Don Guillett
SalesAid Software

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Don,

You forgot the same thing that I did: the key needs to be

Sheets("Test").Range("F2")

if Test is not the activesheet.

Bernie
MS Excel MVP

"Don Guillett" wrote in message
...
try from ANYWHERE.
Sheets("TEST").Range("A1:F129").Sort Key1:=Range("F2"), _
Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, _
MatchCase:=False, _
Orientation:=xlTopToBottom


--
Don Guillett
SalesAid Software

"ToddG" wrote in message
...
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" wrote in
message
...
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 sheet? 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


.

ToddG
Selecting range question
 
Was JUST going to ask you about that. Works just fine now.
Thanks a million
-----Original Message-----
Todd,

Oops, forgot to fully qualify the key range:

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

HTH,
Bernie
MS Excel MVP

"Bernie Deitrick" <deitbe @ consumer dot org wrote in
message
...
Todd,

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


HTH,
Bernie
MS Excel MVP

"ToddG" wrote in
message
...
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" wrote
in
message
...
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 sheet? 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


.





.


All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com