Thread: How to assign a variable in a range select
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
  
Posts: 1,120
Default 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





Reply With QuoteReply With Quote