Hi,
So I'm using VB which transfers data from one worksheet to a master. Commonly at the start of the month the worksheet has no data, and the VB code gives me an error message.
This is the code I am currently using:
So at the start of the month when there could be no data in the excels, when A5:N5 or A6:G6 is selected, then Range(Selection, Selection.End(xlDown)).Select is applied, there is no data so the VB brings back an error.
I could remove Range(Selection, Selection.End(xlDown)).Select and replace it with a selected bottom row, but the amount of data could change at anytime.
Any thoughts/help on this one?
Cheers!
Bookmarks