View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Macdonald David Macdonald is offline
external usenet poster
 
Posts: 26
Default Strange Range copying

This copies the range once:
Sheets("Sheet1").Range("B3:P3").Copy Sheets("Sheet3").Rows(8)

This copies the range repeatedly to the end of the row:
Sheets("Sheet1").Range("B3:Q3").Copy Sheets("Sheet3").Rows(8)

Why? Is there a limit of 15 columns?

--
WinXP - Office2003 (Italian)