View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BillR BillR is offline
external usenet poster
 
Posts: 10
Default Selecting a Range of Columns for Variable Rows

I want to do something like this:
Select a sheet
for row=3 to 17
select cells A:F
copy the cells
Select A2 on another sheet
Paste what I copied.
Shift down 1 row
next row.

I have verything down pretty well except selecting A:F for each row as it
comes up.
I would appreciate any help you can give me.
Thanks.
--
BillR