With Range(Range("R5").Value)
.Font.Name = "Arial"
.Interior.ColorIndex = 5
.NumberFormat = "#,##0.00"
End with
as an example.

or
With Range(Cells(5,"R").Value)

End with

set rng = Range(Cells(5,"R").value)

Just as a side note usually using notation like [R5] is much slower than
using the above form of referencing
--
Regards,
Tom Ogilvy

"Worldman1" wrote:

Hi to All,

I have a macro to sort a table which produces a variable array that I
also want the macro to format. Alongside this array I have a formula
in cell R5 which produces a self-updating text string identifying the
array to be formatted. For example, after sorting, cell R5 contents =
"C7:M15" (the variable array). The result of the formula in R5 will
change each time the macro is run so that it always defines the
dimensions of variable array that I want to format.

How can I get the macro to select the contents of cell R5 as the array
to be operated on? I've found heaps of examples of how a macro can
write to a cell but nothing on how a macro can read from a cell . . .

Thanks if you can help and please don't assume I know a-n-y-t-h-i-n-g

Cheers,
RonW.