Thread: Selecting simple range relative to the active cell.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jmac68 jmac68 is offline
external usenet poster
  
Posts: 1
Default Selecting simple range relative to the active cell.
I need to have my macro select the 9 cells starting with the active cell in
column B and extending 8 cells to the right. I am doing this as a custom
"copy range" funtion in a macro. I do not want an absolute reference for the
range. It should be relative to any ACTIVE cell in column B.

If there is no ACTIVE cell in column B, then I would like to return an error
message "Wrong Column Selected" with and "O.K." button.
Reply With QuoteReply With Quote