Hey Excel Gurus,
How are you? Please if someone could guide me here. I want to clear all contents from cells C5:C100 from all sheets of the workbook except for two sheets namely "HSheet" and "SS"
The range consists of data validation and other formatting which I'd like to keep but remove just the values. I am sure it can be done via vba.
Will appreciate a lot.. anyone?
How are you? Please if someone could guide me here. I want to clear all contents from cells C5:C100 from all sheets of the workbook except for two sheets namely "HSheet" and "SS"
The range consists of data validation and other formatting which I'd like to keep but remove just the values. I am sure it can be done via vba.
Will appreciate a lot.. anyone?