I've searched and found a few posts that come close, but
didn't really hit what I'm trying to do.

I'm having problems determining my range in a macro. I'm
running an equation L=(K-J)/K. I want my range to be K2
thru (the last cell in K that has a value)

Can anyone help me determine the code?

Thanks for your help.

Lonnie

I'm having problems determining my range in a macro. I'm
running an equation L=(K-J)/K. I want my range to be K2
thru (the last cell in K that has a value)

Can anyone help me determine the code?

iRow = Sheets("Sheet1").Range("K65536").End(xlUp).Row
Set rng = Sheets("Sheet1").Range("K2:K" & iRow)

HTH,
Merjet