G
Guest
Guest
How do you create a reference to a range where you need to calculate the bottom right-hand corner of the range? For example, I know the range starts at J8, I know the right-hand edge of the range is column L, and I have a variable that contains the number of rows. I need a reference that looks like:
Range ("J8:L230")
but using the variable instead of 230. How do I do this?
Range ("J8:L230")
but using the variable instead of 230. How do I do this?