N
Needhelp
I have a file with several worksheets all having formulas from row 8 to row
78. I would like to be able create a macro that sets the print range to end
on the row where the last formula has retrieved data on each worksheet. For
example, sheet1 may end on row 31 while sheet2 ends on row 55, etc. The
retrieved data is unique for each row in column B until the last row is
reached where no data is returned. The formula sets these cells to blank.
any suggestions?
78. I would like to be able create a macro that sets the print range to end
on the row where the last formula has retrieved data on each worksheet. For
example, sheet1 may end on row 31 while sheet2 ends on row 55, etc. The
retrieved data is unique for each row in column B until the last row is
reached where no data is returned. The formula sets these cells to blank.
any suggestions?