Excel macro to lookup cell and add new row
Closed
john2191
Posts
1
Registration date
Saturday March 20, 2010
Status
Member
Last seen
March 20, 2010
-
Mar 20, 2010 at 10:12 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Mar 21, 2010 at 03:13 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Mar 21, 2010 at 03:13 PM
Related:
- Excel macro to lookup cell and add new row
- Pdf and xps add in 2007 - Download - Other
- Spell number in excel without macro - Guide
- How to add @ in laptop - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Add accent over e - Guide
1 response
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Mar 21, 2010 at 03:13 PM
Mar 21, 2010 at 03:13 PM
Hello,
Try with this macro :
Best regards
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
Try with this macro :
Sub Insert_Row()
Dim n As Integer
n = Cells(Rows.Count, 1).End(xlUp).Row
Rows(n).Select
Selection.Insert Shift:=xlUp
End Sub
Best regards
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
