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.