I am looking to find the end of the data in my worksheet. The end is ALWAYS a "Report Total" cell in column A:A. I want to find this cell and move down a space or two. The problem is there are going to be multiple "Report Total" cells and also multiple BLANK cells. Someone said to use the following but I am not sure how to use it.
Dim lastRow As Long
Dim lastRowE As Long
lastRow = Cells.Find("Report Total", searchdirection:=xlPrevious).Row
lastRowE = Range("A:A").Find("Report Total",_ searchdirection:=xlPrevious).Row
lastRowE = Range("A" & Rows.Count).End(xlUp).Row
I am not sure how this will work. In the code the "searchdirection" that is there, how will this be replaced? With a "UP", "DOWN", or "xlUP", "xl"Down"?
Thanks for all the help
Dim lastRow As Long
Dim lastRowE As Long
lastRow = Cells.Find("Report Total", searchdirection:=xlPrevious).Row
lastRowE = Range("A:A").Find("Report Total",_ searchdirection:=xlPrevious).Row
lastRowE = Range("A" & Rows.Count).End(xlUp).Row
I am not sure how this will work. In the code the "searchdirection" that is there, how will this be replaced? With a "UP", "DOWN", or "xlUP", "xl"Down"?
Thanks for all the help