hi

i cannot see why this is doing this... any ideas would be greatfully
received.

the first time i run the code it gives me the correct number or rows,
using the

activesheet.usedrange.rows.count

2nd time i use it it counts all the rows in the sheet 65538 (or...)

maybe because the 1st time it runs, it has to check all the way down to
65538 in order to determine what is used (you may have lots of blank
rows & then something on row 20000), which then sets the whole
spreadsheet as "used".
imho
susan


Buffyslay wrote:
hi

i cannot see why this is doing this... any ideas would be greatfully
received.

the first time i run the code it gives me the correct number or rows,
using the

activesheet.usedrange.rows.count

2nd time i use it it counts all the rows in the sheet 65538 (or...)