I have the below VBA that is printing the ranges desired but on separate pages. Does anyone know how I can adjust this so it prints together? Hoping this makes sense - I'm basically wanting to select the columns I want in a table and print the table.
Not sure if it's possible, but I'd also love the VBA to identify the last row in column C with any data and just print the full range down to that row.
Thanks heaps!
VBA Code:
Sub PrintManualEntry2021()
Sheets("2021").Range("a8:c77,ht8:ia77").PrintPreview
End Sub
Not sure if it's possible, but I'd also love the VBA to identify the last row in column C with any data and just print the full range down to that row.
Thanks heaps!