I’m have a worksheet that will be populated by reports. Each report is likely to contain a different number of rows. I’m finding the last row of the main data range by using the far-right column (X). This will work perfectly for these reports.
My problem is that the next 3 lines beneath the last row of the main body of data contains some information such who ran the report, the date, etc. These are on the left side of the page in the first several columns.
I want to merge and aligned these rows differently and use a smaller and lighter font than the rest of the page.
What is the best way to locate these next lines? I’ve tried using similar coding as I did for the last row, only I used column A. This seemed to get me close, but I could include the next couple of rows.
Thanks, any help is appreciated.