How to assign a variable in a range select
 

I tried to assign a variable for a cell range and it returns with an error.
Thanks.

ActiveCell.Offset(0, 1).Select
Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this
code does not work

How to assign a variable in a range select
 

ActiveCell.Offset(0, ,4).Select

--
HTH

Bob Phillips

"Paul" wrote in message
...
I tried to assign a variable for a cell range and it returns with an
error.
Thanks.

ActiveCell.Offset(0, 1).Select
Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0,
4)").Select........this
code does not work

How to assign a variable in a range select
 

You are soooooo close:

Range(ActiveCell.Offset(0, 0).Address & ":" & ActiveCell.Offset(0,
4).Address).Select

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Paul" wrote in message
...
I tried to assign a variable for a cell range and it returns with an error.
Thanks.

ActiveCell.Offset(0, 1).Select
Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0,
4)").Select........this code does not work

How to assign a variable in a range select
 

No Luck...Does not work

ActiveCell.Offset(0, 1).Select........Need this one to establish the new
location
Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select....then I
need to highlight the cell from above plus 4 cells to the right

"Bob Phillips" wrote in message
...
ActiveCell.Offset(0, ,4).Select

--
HTH

Bob Phillips

"Paul" wrote in message
...
I tried to assign a variable for a cell range and it returns with an
error.
Thanks.

ActiveCell.Offset(0, 1).Select
Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0,
4)").Select........this
code does not work

How to assign a variable in a range select
 

Thanks...It is working

"George Nicholson" wrote in message
...
You are soooooo close:

Range(ActiveCell.Offset(0, 0).Address & ":" & ActiveCell.Offset(0,
4).Address).Select

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Paul" wrote in message
...
I tried to assign a variable for a cell range and it returns with an
error. Thanks.

ActiveCell.Offset(0, 1).Select
Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0,
4)").Select........this code does not work

How to assign a variable in a range select
 

Another way...

activecell.resize(1,5).select



Paul wrote:

I tried to assign a variable for a cell range and it returns with an error.
Thanks.

ActiveCell.Offset(0, 1).Select
Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this
code does not work

--

Dave Peterson