View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert H Robert H is offline
external usenet poster
 
Posts: 113
Default Select range between column and row

sorry, the OP was incomplete

In a large field of data I have definded a range from a segment of the
top row.
colAdd is a string = $H$1,$I$1,$J$1,$K$1,$L$1,$M$1
I want to return all the cells down for all columns using something
like Selection.End(xlDown)

Ive tried severa manipulations
Set preSrcRng = Range(colAdd).End(xlDown)