Problem with Circular References
Posted on 2012-08-22
I have a spreadsheet containing percentage numbers. I want to remove those % sign by writing a macro that formats those percentage numbers to general number then mutiply by 100. For example, 4.5% will change to 4.5 after running the macro. The sample code is below
.Range("P19").NumberFormat = "General"
.Range("P19").FormulaR1C1 = "=RC*100"
.Range("P19").AutoFill Destination:=.Range("P19:P200"), Type:=xlFillDefault
When running this, all i get is 0 values range from P19 to P200 and I notice there's a Circular References warning in the status bar. How can i fix this?