I have a worksheet with data in multiple columns, only someof which I need to select. The routineworks fine when all the cells in the range are populated but where there is nosale against a product some of the rows are blank.
For each product code I am selecting the 2 columns MyColFand MyColF1...