Multiply selection of cells by x, whilst keeping formulas and formats, using VBA

[jaykay1]

Hi,

I constantly have to change the factor of a large series of random cells, usually by a thousand or a hundred.

I can for example

• enter "100" in a random cell,
• click copy,
• highlight all the cells I need to change,
• paste special - formulas - multiply.
• But, when doing this as frequently as I do, it takes a while!

Does anyone know how I can do this in VBA, so that I can just highlight the cells, run the macro and it will automatically paste special, formulas, multiply by say "100" for every cell?

Any help would be greatly appreciated!
Jay

 

[Rick Rothstein]

Duplicate posting... http://www.mrexcel.com/forum/excel-...ng-visual-basic-applications.html#post3984930

@jaykay1,

You should only post your question once so that others do not waste their time creating solutions that someone else may have offered in your other posting.