G
Guest
Guest
Hope I ask this properly.
I have a dummy spreadsheet set up for the quoting Dept. Range for each can be small to all columns and 10000+ rows.
I only want to print a specific range
lets say B1:F1000. Basically I
want to print to the last active cell in F
which contains data .
Is there coding that will examine a range and determine where the data ends, and I can then set the print area I desire?
I have a dummy spreadsheet set up for the quoting Dept. Range for each can be small to all columns and 10000+ rows.
I only want to print a specific range
lets say B1:F1000. Basically I
want to print to the last active cell in F
which contains data .
Is there coding that will examine a range and determine where the data ends, and I can then set the print area I desire?