VBA error with Set Range

[goss]

Hi all,

Using Excel 2007

Code below I think it should select blank cells down Column E
But the debug.print returns $E$1:$J$1
What am I doing wrong?
lngRowsTmp = 10526 which is correct

thx
w

Please Login or Register  to view this content.

[Norie]

There's nothing wrong with that code but it will error if there are no blank cells in E1:E10526.

[goss]

Thanks Norie,

There are blanks, looks to be 15 or so.
Any thoughts as so why debug.print returns an address of $E$1:$J$1?

I expect something more like $E$4,$E$98,$E$1234,$E$5698,.....

thx
w

[Norie]

Do you have any merged cells?

[goss]

No merged cells

thx
w

[Norie]

I can't see why you would get that result.

Can you attach a sample workbook?

[goss]

Thanks

The data is proprietary
I'll generate some random data later tonight and upload.

thx
w