Dim UsdRws As Long
UsdRws = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Range("J2:J" & UsdRws).FormulaR1C1 = "=VLOOKUP(RC1,'PRISM History'!R1:R" & UsdRws & ",21,FALSE)"
Sorry for all the questions. I am confident in my excel skills until it comes to macros and then I am just lost. Maybe it would help if I gave you the whole code haha.
The parts I am wanting to change are the ranges it says autofill on. These ranges vary from time to time and I would like for them to auto adjust as opposed to me changing the row count. I know it is decently lengthy code but I think only the autofill ranges would need to change.