View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom[_7_] tom[_7_] is offline
external usenet poster
 
Posts: 24
Default ActiveCell.Copy Cells(1, intRow) limited to 255 Rows?

Through a little testing I have found that the following statement
won't work if intRow is greater than 255

ActiveCell.Copy Cells(1, intRow)

This is true if Cells(1,256) is used.

How do I get past this limitation?

Thanks

-tom