View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chuck Mryglot Chuck Mryglot is offline
external usenet poster
 
Posts: 2
Default Finding ranges in an array, cut and paste also.


Hi Alan.
I have 8 columns of data...with a heading at the top of each
column...e.g. row 1 is headings and data starts in row 2. The data is
sorted. I need to look down one of the columns until I find a
particular integer value. Then I need to copy everything from row 2 down
to the row in which I found the integer I was looking for....call it row
n .....and past the 8 columns (with headings) from row 1 to row m onto a
new sheet.
chuck


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!