| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create macros to print specific cells
Hi, I would like to create several buttons in order to
print specific cells. Could anyone help me? Thanks.. regards, Richy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create macros to print specific cells
Richy,
You can print a cell or range of cells with code like Range("A1:A10").PrintOut -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Richy" wrote in message ... Hi, I would like to create several buttons in order to print specific cells. Could anyone help me? Thanks.. regards, Richy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create macros to print specific cells
Hi Chip,
thanks for the tip. It's very helpful, however how could I print something from other sheet's? Thanks omce again. Richy -----Original Message----- Richy, You can print a cell or range of cells with code like Range("A1:A10").PrintOut -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Richy" wrote in message ... Hi, I would like to create several buttons in order to print specific cells. Could anyone help me? Thanks.. regards, Richy . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create macros to print specific cells
Richy,
Just qualify the range with the worksheet name. E.g., Worksheets("Sheet2").Range("A1:A10").PrintOut -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Richy" wrote in message ... Hi Chip, thanks for the tip. It's very helpful, however how could I print something from other sheet's? Thanks omce again. Richy -----Original Message----- Richy, You can print a cell or range of cells with code like Range("A1:A10").PrintOut -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Richy" wrote in message ... Hi, I would like to create several buttons in order to print specific cells. Could anyone help me? Thanks.. regards, Richy . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print specific cells to another worksheet if check box cell links | Excel Discussion (Misc queries) | |||
| How do I create a hyperlink in Excel on specific words in cells? | Excel Discussion (Misc queries) | |||
| HOW DO I NOT PRINT SPECIFIC CELLS IN EXCELL | Excel Discussion (Misc queries) | |||
| Setting Specific Cells To Not Print | Excel Discussion (Misc queries) | |||
| print specific cells | Excel Discussion (Misc queries) | |||
Linear Mode
