Unable to get the SpecialCells property

[6cef]

wrote some code works fine in Excel, but from a .vbs file, it chokes.

the offending line:

lastRow = .Cells.SpecialCells(xlLastCell).Row​

the error:

"Unable to get the SpecialCells property of the Range class"​

if i change that to:

lastRow = 100​

works fine, but obviously, loose the dynamism of using xlLastCell.

any insight into cause appreciated.

-colin

 

[Richard Schollar]

Try swapping this:

xlLastCell

with its value (11), so:

lastRow = .Cells.SpecialCells(11).Row​

 

[6cef]

ah! works perfectly.

thank you, richard.

-colin