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

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" <tomfeldsten@hotmail.com> wrote in message news:1130344204.596668.269330@g14g2000cwa.googlegroups.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
>

> 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