Hello
I have a workbook with 8 sheets (sheet1 to sheet8)
in cell A1 on sheet I have a variable number eg 3
i want this number to be used as a column identifier eg 3 = column C, 4 = column D etc
So i then want select sheets 2 to 5 and select range C8 to M8 and enter the value "0" in that range and also for range C12 to M12 and enter the Value "0" also (where C in the above range is determined by cell A1 value above).
Any Help much appreciated.
I have a workbook with 8 sheets (sheet1 to sheet8)
in cell A1 on sheet I have a variable number eg 3
i want this number to be used as a column identifier eg 3 = column C, 4 = column D etc
So i then want select sheets 2 to 5 and select range C8 to M8 and enter the value "0" in that range and also for range C12 to M12 and enter the Value "0" also (where C in the above range is determined by cell A1 value above).
Any Help much appreciated.