I have a workbook whose rows and columns contents may vary (although the
formulas in the cells will remain because they are external links to a data
file). There are 6 sheets which all will need to use the solution
independently.

What I need to do is have my Print Area be dynamic based on the cell
contents (only print a block of cells that have non 0's and blanks).

I have a cell whose formula yields a text string which I want the Print Area
command to use. When I try to define a Name and point to the cell containing
the text string, it uses the cell location not the contents. How can I change
that?

The following formula gets my height based on amount of text in column A and
width based on Row 8.
=CONCATENATE("$A$1:"&"$"&CHAR(65+MAX(A8:V8)-1)&"$"&COUNTA(A1:A65535))
I realize this will only work for the first 24 columns but I can fix it
beyond that if I get to that point.

As stated above, I will need to apply this method to each sheet within the
workbook as they each may be different. (So I'll need different Dynamic Areas
per sheet.)

I have tried to use the OFFSET command but with no luck.

All ideas will be tried and appreciated. Thanks in advance.
George