I'm creating a macro to add data to the end of a list. When imported, the data has three header rows. The first row of headers is found using:
From there,
...takes you to the first row of actual data. I now want the macro to capture how many rows of data (including that row) exist. Call it a pre-created variable named RowsWithData
How do I do that?![Unsure :unsure: :unsure:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Code:
Cells.Find(What:="Date:", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False).Activate
Code:
Activecell.Offset(4, 0).Select
How do I do that?