I've got a workbook in which a user inputs values into cells on sheet
1, and then the info is copied to a log sheet. I'm using the following
code to find the next empty row in the log sheet to paste the info:
With historyWks
lastRow = .Cells(.Rows.Count, "A").End(xlUp).Offset(1,
0).Row - 1
lLastRec = lastRow - 1
End With
>From time to time, I'm told that an existing entry has been
overwritten with new data.
Should I be using something different to find the next empty row ?
Thanks
Jeff
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
