Printing A1 to last non blank cell in F (but may contain formula)
Posted by Danny on September 12, 2000 1:53 PM
I am currently using the following code for printing
ActiveCell.Name = "mystop"
ActiveSheet.PageSetup.PrintArea = ("A1:mystop")
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
The problem is that I have the formula:
in the F column (the value 1 changes down the column),
so going to the last cell in the F column for a print
area does not work. How can I change the code (and
maybe clean it up a little), to set the print area to
(A1:"the last blank value in column F"). Greater than
0 won't work either because the last value in F may be 0.
Thanks in advance.