View Single Post
  #1   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

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

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