Printout By Defining A Cell Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub ImpZoneEtTitle() With Worksheets("Sayfa1").PageSetup .CenterHorizontally = True .PrintArea = "$A$10:$G$15" .PrintTitleRows = ("$A$1:$A$2") .Orientation = xlPortrait .FitToPagesWide = 1 .FitToPagesTall = 1 End With Worksheets("Sayfa1").PrintOut End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 printout by defining a cell 2 excel operators hk 3 specify the number of copies to print from the printer 4 prints cells with data 5 time in cell (by defining name to cell) 6 printing and prompting 7 print command in workbook 8 only printing cell a1 9 font size and character in cell a1 only when sending to the printer in arial-italic and 14 points 10 number of sheet / page prints with message box (prints even if the sheet / page is blank) 11 active cell printing 12 print out the specified range of cells 13 prints desired cells vertically 14 output from the printer as many as the number in the cell 15 prints selected areas on a sheet of paper 16 prints selected areas on a sheet of paper 17 print inside cells with a certain print area but only filled 18 a3: prints data between cells f15 19 output as many as the number in the cell 20 Moon learning in cell (defining function)