Apply formula to all values in range

Hi everyone,

I have a range of numeric values populating in columns F:R. The number of rows populated will value for each use. All I'm trying to do is put together a macro that will take the value in each cell within columns F:R and divided by 37.5 and then multiple the total by 100. Something like this:

F2Value = 3
F2NewValue = (3/37.5) * 100 = 8%
F3Value = 4
F3NewValue = (4/37.5) * 100 = 10.67%

Any help would be greatly appreciated.

Thanks!

This assumes there are headings in row 1, that the data stars in row2, that there are no blank rows in the data, or blank columns between columns F and R
Run the macro from the sheet that you want to amend

Please Login or Register  to view this content.