-
This is default featured slide 1 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
-
This is default featured slide 2 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
-
This is default featured slide 3 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
-
This is default featured slide 4 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
-
This is default featured slide 5 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
PSD COTES,HAIRS,DRESSES,HATS, & BACKGROUNDS
Excel Macro : Excel VBA code to Print the Sheet
Syntax of .PrintOut Method
Where:
|
Examples:
Example 1: VBA Statements to Print Objects with Default Options
1. VBA code to print ActiveWorkbook
- Function PrintActiveWorkbook()
- ActiveWorkbook.PrintOut
- End Function
2. VBA code to print Active Sheet
- Function PrintActiveSheet()
- ActiveSheet.PrintOut
- End Function
3. VBA code to print all WorkSheets
- Function PrintAllWorkSheets()
- WorkSheets.PrintOut
- End Function
4. VBA code to print a Single Sheet
- Function PrintOneSheet()
- Sheets("Sheet1").PrintOut 'Sheet1 is the name of the Sheet which you want to Print
- End Function
5. VBA code to print more than one Sheet
- Function PrintMultipleSheets()
- Sheets(Array("Sheet1" , "Sheet2", "Sheet3").PrintOut
- End Function
6. VBA code to print Selected area of a Sheet
- Function PrintSelectedArea()
- Selection.PrintOut
- End Function
7. VBA code to print Range of Worksheet
- Function PrintRange()
- Range("A1:D5").PrintOut
- End Function
8. VBA code to print Excel Chart
- Function PrintChart()
- Sheets("Sheet1").ChartObjects("Chart1").Chart.PrintOut 'Chart1 is name of the Chart
- End Function
9. VBA code to print All Charts in a WorkSheet
- Function PrintAllChart()
- Dim ExcelCharts As Object
- Set ExcelCharts = Sheets("Sheet1").ChartObjects
- For Each Chart In ExcelCharts
- Chart.Chart.PrintOut
- Next
- End Function
10. VBA code to print All Charts in a Workbook
- Function PrintAllChart()
- Dim ExcelCharts As Object
- For Each Sheet In Sheets
- Set ExcelCharts = Sheet.ChartObjects
- For Each Chart In ExcelCharts
- Chart.Chart.PrintOut
- Next
- Set ExcelCharts = Nothing
- Next
- End Function
Example 2: VBA Statements to Print Objects with different parameters passed
1. VBA code to print From Page Number X to Page Number Y
- 'Below statement will print from Page No:2 to Page No:3
- Worksheets("Sheet1").PrintOut From:=2, To:=3
2. VBA code to print more than 1 Copy
- 'Below statement will print 3 copy of the Sheet1 from Page 2 to Page no: 3
- Worksheets("Sheet1").PrintOut From:=2, To:=3, Copies:=3
3. VBA code to Show Print Preview before actual printing
- 'Below statement will print 3 copy of the Sheet1 from Page 2 to Page no: 3
- Worksheets("Sheet1").PrintOut From:=2, To:=3, Copies:=3, Preview:=True
এক ক্লিকে Windows 10 এর সব Settings আপনার হাতের মুঠোয়|
এ কাজটা খুবই সহজ, চলুন এবার দেখা যাক।
Left Button এ click করুন। নীচের ছবির মত করে….
তো আজ আমি আপনাদের দেখাবো, Windows-10 এর সকল Settings সুমহ কিভাবে Shortcut Accessকরা যায়।
এ কাজটা খুবই সহজ, চলুন এবার দেখা যাক।
Left Button এ click করুন।