Hello everyone,
Been a while since I have been here but I have an issue that I am hoping you can help me with. I have declared a variable with the following...
Dim LR As Long LR = Range("C13:AI13").End(xlDown).Row Dim R1 As Range Set R1 = Range("C13:N" & LR) R1.Select
...which works perfectly to select the entire range, no more and no less. however after I sort this selection I have code that adds a line to the worksheet at row 13, does some formatting, sets some formulas etc. and later I use the "R1.Select" again and it selects the entire range again except it starts at row 14 instead of 13 as the Dim Statement says... URGGGHHH, very frustrating. Can anyone help? Uhhh, stupid question, you all have always been super helpful. Thank you in advance!