MICHAELREXCEL
New Member
- Joined
- Oct 4, 2016
- Messages
- 17
Hello,
I am trying to copy data from row 160 and paste it on rows 161 to 183 (the last row). Normally, this code would be easy to write, however rows 161 to 183 have blank cells at the beginning. Therefore, I cannot do the typical "range.end" methodology. Also, the row numbers will change all the time since the amount of data frequently changes.
Is there a way to write a VBA code that does this? Any help is welcomed.
Thanks
I am trying to copy data from row 160 and paste it on rows 161 to 183 (the last row). Normally, this code would be easy to write, however rows 161 to 183 have blank cells at the beginning. Therefore, I cannot do the typical "range.end" methodology. Also, the row numbers will change all the time since the amount of data frequently changes.
Is there a way to write a VBA code that does this? Any help is welcomed.
Thanks