hi Arnel. you have 2 modules, so which are you referring to. if it's 46 rows, i'm assuming it's module 1. to edit the code, press ALT + F11 to access the VBA window. press CTRL + R if you don't see the project Explorer on the left. double-click Module 1 there to edit it.
this code below helps you obtain the last row. based on your data, i can use column E or F to determine the last row since they have no empty cells. so:
Rows.count will count the total number of rows in Excel. in xlsm, it will be 1 million over. in xls, it will be 65000 over. from the total rows, it then finds the last filled row on top. that will bring you to row 46 in this case. with that, you can change your codes to:
do the same for all row 46.
another tip. while recording, you would have scrolled here and there. remove them to make your codes cleaner and run faster.
and if you ever see a .select, try to combine the next code with it. if you fail, simply revert it back. for eg.
this could be reduced to:
LinkBack URL
About LinkBacks
Register To Reply
Thanks, if you have clicked on the * and added our rep.
Bookmarks