Thread: From active cell, select the next 10 rows down, 6 columns over.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default From active cell, select the next 10 rows down, 6 columns over.
Range(Cells(activecell.Row,activecell.Column),
Cells(activecell.Row+10,activecell.Column+6)).sele ct

--
If this post helps click Yes
---------------
Jacob Skaria


"J.W. Aldridge" wrote:

From active cell, select the next 10 rows down, 6 columns over.

Reply With QuoteReply With Quote