I have a spreadsheet with 2 tabs of data. When someone needs to run a new report, I have a macro that will clear out any numbers below the Headers in row 2 that were already there. This works great except when the user is starting with empty cells. Then the macro clears out the headers (something with the End(xlUp).Row, I assume). I tried checking for content in A3 of each tab but that will only work if both are empty or both are full and I can't guarantee this will be true.
VBA Code:
Dim Lastrow1, Lastrow2 As Integer
Lastrow1 = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Range("A3:V" & Lastrow1).Select
Selection.Clear