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