T theFrog Nov 9, 2003 #1 I want to grab the text in a cell (company's name) and automatically copy it to the header using a macro. Thanks for any help. Mike
I want to grab the text in a cell (company's name) and automatically copy it to the header using a macro. Thanks for any help. Mike
C Chip Pearson Nov 9, 2003 #2 Mike, Try something like ActiveSheet.PageSetup.LeftHeader = ActiveSheet.Range("A1").Text -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
Mike, Try something like ActiveSheet.PageSetup.LeftHeader = ActiveSheet.Range("A1").Text -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
