| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Change Column Headings
I receive data from outsdie vendors and I would like to know if I would be
able to change column heading descriptions via a macro. For example A1 I would need changed from BrLoc to Branch ID. B1 Mftg Part No would be changed to Part Number etc. Thanks. -- Bob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Change Column Headings
Sub namefixer()
s = Array("Branch ID", "Part Number") Range("A1:B1") = s End Sub add as many titles as you like. -- Gary''s Student - gsnu200776 "Bob" wrote: I receive data from outsdie vendors and I would like to know if I would be able to change column heading descriptions via a macro. For example A1 I would need changed from BrLoc to Branch ID. B1 Mftg Part No would be changed to Part Number etc. Thanks. -- Bob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Change Column Headings
Thanks. Exactly what I needed.
-- Bob "Gary''s Student" wrote: Sub namefixer() s = Array("Branch ID", "Part Number") Range("A1:B1") = s End Sub add as many titles as you like. -- Gary''s Student - gsnu200776 "Bob" wrote: I receive data from outsdie vendors and I would like to know if I would be able to change column heading descriptions via a macro. For example A1 I would need changed from BrLoc to Branch ID. B1 Mftg Part No would be changed to Part Number etc. Thanks. -- Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| How do I change column and row headings. | Excel Discussion (Misc queries) | |||
| Is it possible to change a template column headings? If so how? | Excel Worksheet Functions | |||
| Can I change column headings A,B,C etc to words | Setting up and Configuration of Excel | |||
| How do I change the column headings in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
