I am finishing the end of a macro and am having a couple of problems. Everything is fine upto this point
....
Range("a6000").Select
ActiveCell.End(xlUp).Select
lastrow = ActiveCell.Row
I need the active cell to move down one row.
Once it goes down one row, I need to select the range from that cell to row 3000.
Any Suggestions. I do not know a lot of VB, I have made macros from bits and pieces from postings on this website.
Thanks for all your help.
....
Range("a6000").Select
ActiveCell.End(xlUp).Select
lastrow = ActiveCell.Row
I need the active cell to move down one row.
Once it goes down one row, I need to select the range from that cell to row 3000.
Any Suggestions. I do not know a lot of VB, I have made macros from bits and pieces from postings on this website.
Thanks for all your help.