I'm having a little issue with the xlUp code. My macro downloads data from an As/400 system. I then add a chart selecting all data in column B as data source starting at B2 to the end of the data. The data in column B ends at B10, when I try the xlup command, it stops at B13 which is empty. I have tried adding code to the macro deleting all rows between B10 and B13, still the xlUp stops at B13. I don't know if anyone has any ideas but I'm at a dead loss.
Cheers
Matt
Cheers
Matt