loop formula to occur "N" times

hello. I'll preface this by saying i have limited VBA experience.

I have a formula that i want to run N times, where N is the number of decimal places in a cell reference.

I'm attempting to convert a performance scale that goes from 100% - 110% to 100% - 150%

Please Login or Register  to view this content.

It is not clear to me where you draw the value of N from.
Assuming N = 5
try the following codes

Please Login or Register  to view this content.

Run the macro. it will place the calculated values in col R rows 1 to N.
Ravi

N is the number of values after the decimal place. for instance, with 105.4897 N=4



SHG, your formula looks much simpler, and was what i started trying to find on my own. i have to ask though, how did you come up with the 5 and the 4? The scale range i gave as an example was only on scenario, there are more ranges i have to convert.