R Richy Feb 16, 2004 #1 Hi, I would like to create several buttons in order to print specific cells. Could anyone help me? Thanks.. regards, Richy
Hi, I would like to create several buttons in order to print specific cells. Could anyone help me? Thanks.. regards, Richy
C Chip Pearson Feb 16, 2004 #2 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, 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
R Richy Feb 17, 2004 #3 Hi Chip, thanks for the tip. It's very helpful, however how could I print something from other sheet's? Thanks omce again. Richy
Hi Chip, thanks for the tip. It's very helpful, however how could I print something from other sheet's? Thanks omce again. Richy
C Chip Pearson Feb 17, 2004 #4 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, 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
