Hi All,
I have VBA code that selects a range on the active sheet and all the code works fine and does what is asked, however I would like to change the range to another sheet within the workbook (Sheet2).The code works fine for the first four tasks,and colours the selected cells specified within the range, however for the next two tasks it populates the correct cells on (Sheet2) with the correct data but colours the cells on the active sheet.I cannot seem to find a solution any help appreciated.
Thanks
Spagbog

HTML Code: