bamaisgreat
Well-known Member
- Joined
- Jan 23, 2012
- Messages
- 831
- Office Version
- 365
- Platform
- Windows
I need the code I have for finding first empty row to ignore the data i have in column A. I have data in row 1 also. Im not sure how to adjust the code below. Thanks for the help as always
Code:
iRow = ws.Cells.Find(What:="*", SearchOrder:=x1Rows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1