Printing help

[Graham JN]

HI

Can any one save me !!

I have a sheet which populates with information (the info that populates changes in the number of rows but the columns are generally set

I would like a VBA which

Specifies the fix columns for printing for example column B to F

I would like it to specify the first row the printing starts from for example row 6

Then I would like it to only print down to the row of a specific column C, it stops at the print range at which there is nothing in the cell


So my variables are it only ever prints the column range B to F

It starts printing at row 6

Then it stops printing when there is no data (the cell is empty in column C) for example C56 (however 56 variable depending on cell content)

That makes my print range on this sheet become
B6:F6
B56:F56



Someone make me happy

 

[Joe4]

Is this what you are after?

Sub SetPrintArea()

    Dim lr As Long
    
'   Find last row in column C withdata
    lr = Cells(Rows.Count, "C").End(xlUp).Row
    
'   Set print area
    ActiveSheet.PageSetup.PrintArea = "B6:F" & lr
    
End Sub