Tark221
Registered User.
- Local time
- Today, 07:58
- Joined
- Oct 12, 2012
- Messages
- 74
When submitting the data into the newly created spreadsheet for some reason it's entering it into row 14
i thought this code made it so it entered it in the next free row which would make it the second row down from the top
Dim iRow As Long
'find first empty row in database
iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
End If
any suggestions?
i thought this code made it so it entered it in the next free row which would make it the second row down from the top
Dim iRow As Long
'find first empty row in database
iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
End If
any suggestions?