Print some Cells in Excel - VBA Code

Sample VBA Code to print some cells (change the cell number in the code)


Sub PrintSomeCells()
Sheets("Costing").Rows("18:71").EntireRow.Hidden = True
Range("D1:H100").PrintPreview
Sheets("Costing").Rows("18:71").EntireRow.Hidden = False
End Sub