One thing I've come across is that using ActiveSheet.UsedRange.(Rows|Columns).Count is the best way to get the total number of rows/columns. Not sure if that's the issue here, but give it a shot.
__________________
Greetings and salutations.
Last edited by Moskie; 08-07-2005 at 04:09 AM..
|