I have a macro in which I have the line:
Range (A1:I8).select

The problem is that the row number in Col. I varies.

I would like to get the range from cell L2 in my worksheet and continue the rest of the macro. I can make the proper range in cell L2 I just need to know how to make visual basic look at that cell to determine the range it selects.

Can anyone help me?