Excel VBA - Working with a worksheet and FormulaR1C1
Posted on 2003-03-10
I have an existing worksheet where I need to convert values within the range to a percentage format. The values are read into the worksheet from a file, therefore I do not know what the range is.
I have tried the following piece of code, however, I am getting a compile error, stating that "Argument not optional" the word range is highlighted in the line: Sum(.Range.Cells / 40 * 100).
Would anyone have any ideas how to correct this error?
Dim R As Range
Set R = .Range(.Range(RawDataSearch), .Cells.SpecialCells(xlCellTypeLastCell))
.Range.Cells.FormulaR1C1 = Sum(.Range.Cells / 40 * 100)
Set R = Nothing
many thanks for help or suggestions in advance