How to return the result of a cell's formula as an argument within a
running macro?

Hi to All,

I'm sorting a table to extract data which becomes a new variable
array (variable number of rows but columns don't change and top left
is always the same cell address - in this case C7)

Alongside this array in cell R5 I have a formula which automatically
calculates the variable array dimensions. Let's say for example this
returns the text string C7:M32

The macro gets to the point of having done the sorting, the new data is
all nicely arranged in the variable array and cell R5 has updated
itself. Perfect so far!

I then want the macro to set the print area to the array dimensions
calculated in R5 and this is where I get stuck. I have found heaps of
examples on how macros can write data to a cell but nothing on how a
macro can read data from a cell to be used as an argument within the
macro. Perplexed. A great big "Thanks!" to anyone who can help.

Cheers,
RonW.

PS: please don't assume I know anything at all about VBA and macro
programming . . .