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...)