Add column # dynamically in row 1 of a particular worksheet
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
|