Thanks in advance to all that try to assist.
I have attached a sheet where we use the following VBA code to determine the last recorded row of data in column G. Normally this sheet would have some 3k plus rows, but i have only shown the first few to keep the file small etc.
VST3DR is a declared variable. This holds the result to be used in a print routine to determine how many rows require printing.
My issue is that some of the users need to print before all or even any entries are entered into column G.
We could use the old fashioned method of simply highlighting the required cells and go to file then print in normal excel operations. However we need to control what printers are used hence wish to automate this option and control at the same time.
I need to find a way coding wise to be able to determine the last row where data is displayed, bearing in mind that all the rows contain formulas that display BLANK so the ISBLANK functions do not work. Nor do i wish to be printing 3k+ rows if only 100 are actually holding visible data.