| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveCell.Copy Cells(1, intRow) limited to 255 Rows?
Hi Tom
How do I get past this limitation? You can't There are only 256 columns in Excel The next Excel version will have more -- Regards Ron de Bruin http://www.rondebruin.nl "tom" wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveCell.Copy Cells(1, intRow) limited to 255 Rows?
There are only 256 columns in Excel The next Excel version will have more.
Thanks. I noticed my incorrect reference to Rows when I meant columns. Thanks for catching that. -tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| limited columns and rows number | New Users to Excel | |||
| Copy File from activecell | Excel Discussion (Misc queries) | |||
| How do I create an Excel worksheet with a limited no. of rows? | Excel Discussion (Misc queries) | |||
| ActiveCell.Copy Range("R3C27") | New Users to Excel | |||
| Delete rows from activecell | Excel Programming | |||
![tom[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
