dtms1
07-28-2012, 01:58 PM
Hi,
So I have the excel sheet where one of the columns are all numbers. They are in a format of just XXXXX where X are just digits from 0-9. They are not equations (no = sign in front of cell or formula bar).
However for each column down I would like to subtract a constant number down through all the columns. How can I approach this in VBA to have it do all 5000 cells automatically?
thank you
So I have the excel sheet where one of the columns are all numbers. They are in a format of just XXXXX where X are just digits from 0-9. They are not equations (no = sign in front of cell or formula bar).
However for each column down I would like to subtract a constant number down through all the columns. How can I approach this in VBA to have it do all 5000 cells automatically?
thank you