Hi ABBOV,

Your title said "variable row".
When you code with Range("B1:B1000") this is fixed and does not change.

If you code with Range("B1:B" & ActiveSheet.UsedRange.Rows.count)
the number of rows varies based on the value after the "&".

I was seeing if this syntax might help you.