|
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 |
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 |
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 . |
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 . |
| All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com