Hi,

I have a numeric value x representing the number of rows. I would like to
have the range statement use x so the user does not have to manually modify
the range, as the number of rows for a file will vary. Can someone provide me
with the syntax to use for the Would like scenario? Is there a symbolic
parameter I can use to do this?

Currently:
Range("BE1:BE179").Select

Would like:
Range("BE1:BEx").Select

Thanks,

Bob