Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to use row 1 of a particular worksheet to include the column # in
each and every column of the worksheet. As I add/insert a new column anywear on the worksheet, it should automatically re-adjust the column numbers without having to copy or resequence the column numbers (i.e., every single column should have a formula "=columns()"). Is this possible using VBA code? If so, can someone please post the code. Thanks in advance for your help. Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamically setting worksheet tab colors | Excel Worksheet Functions | |||
Creating a Dynamically Linked Worksheet | Excel Worksheet Functions | |||
Dynamically populating a 14-column listbox | Excel Programming | |||
Dynamically adding data after the last column | Excel Programming | |||
Dynamically adding a macro to a new worksheet | Excel Programming |