Macro to populate formula using Autofill
Closed
mayek25
Posts
4
Registration date
Thursday July 4, 2013
Status
Member
Last seen
July 16, 2013
-
Jul 4, 2013 at 09:45 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 15, 2013 at 11:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 15, 2013 at 11:26 AM
Related:
- Macro to populate formula using Autofill
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 9, 2013 at 11:50 AM
Jul 9, 2013 at 11:50 AM
Hi Mayek,
Here is your requested code:
Best regards,
Trowa
Here is your requested code:
Sub AutofillGHJ() Dim lRow As Integer Sheets("B").Select lRow = Range("B" & Rows.Count).End(xlUp).Row Range("G1:H1").Autofill Range("G1:H" & lRow) Range("J1").Autofill Range("J1:J" & lRow) End Sub
Best regards,
Trowa
mayek25
Posts
4
Registration date
Thursday July 4, 2013
Status
Member
Last seen
July 16, 2013
Jul 9, 2013 at 09:01 PM
Jul 9, 2013 at 09:01 PM
Hi Trowa,
I actually managed to figure out the macros by using recording and modifying it from there. Although it is slightly long, but its workable. The macros you had provided are very simple and workable.
Thank you.
Regards
I actually managed to figure out the macros by using recording and modifying it from there. Although it is slightly long, but its workable. The macros you had provided are very simple and workable.
Thank you.
Regards
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 15, 2013 at 11:26 AM
Jul 15, 2013 at 11:26 AM
Hi Mayek,
Hopefully it will help you in creating smaller macro's. As this will be beneficial to the file size.
Best regards,
Trowa
Hopefully it will help you in creating smaller macro's. As this will be beneficial to the file size.
Best regards,
Trowa