NeilATaylor
Board Regular
- Joined
- Aug 7, 2007
- Messages
- 185
Sheets("Pivot Table").Select
Range("a1").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveWorkbook.Names.Add Name:="PivotTable", RefersToR1C1:=Selection
Range("a1").Select
How do I modify this to highlight and name ann number of columns, as well as rows, and name as range "PivotTable"?
Thanks!
Range("a1").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveWorkbook.Names.Add Name:="PivotTable", RefersToR1C1:=Selection
Range("a1").Select
How do I modify this to highlight and name ann number of columns, as well as rows, and name as range "PivotTable"?
Thanks!