Hi

I am using below function to select fix range, how can I change "100" with a
variable, so it select from "A2" upto last row which have entry.

Range("A2:AN100").Select

Regards