Hi

This macro is exactly what I need also, except it's not working-- because I
have an "ifand" formula in cells to return the value "corner".
The macro is setting the end of the print range at the first cell it sees
the formula, not the returned value "corner"

How do I tweak this?

"Don Guillett" wrote:

If that's really what you want to do

Sub printrng()
Range("a1:" & Cells.Find("corner").Address).PrintPreview
End Sub

--
Don Guillett
SalesAid Software

"Paul H" wrote in message
...
I want to print a sheet with the upper left point being A1 with the bottom
right point variable. I could put a word in the cell (i.e. corner), I
need
a macro to look through the sheet and find the word "corner" this would
then
be used as the bottom right point for the print setup. Any ideas?