Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Print some Cells in Excel - VBA Code
#1
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
Reply
#1
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
Reply
CAA


Forum Jump:


Users browsing this thread: 1 Guest(s)