if exists find last values in variable rows

Originally Posted by MarvinP

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.

Marvin,

Thanks, your right, it's not the complete answer to my problem but it helps me understand vba.

Best Regards,

ABBOV