Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Kayrow
-
Copy and paste rows between sheets
Thanks lambuhere1. Works like a dream. I've chucked some code in to find the last row rather than going to a thousand, so it looks like: Global IntRowStart As Integer Sub Delete() range("A1").Select selection.End(xlDown).Select ActiveCell.Offset(1, 0).range("A1").Select...- Kayrow
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy and paste rows between sheets
I'd like to cycle through about 1000 rows in a sheet and copy all rows that have data into another sheet. OR simply delete all the completely blank rows. Has any one got some code to do this?- Kayrow
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
