philfer
12-15-2008, 06:28 AM
Hello,
If I have a named range say of cells A1 to AD1 which can grow and shrink i.e. users can add columns anywhere in the middle, is there a way of finding the last column in the current range (i.e. given its current size).
I'd like to be able to find the column index i.e that it is column 28 for example
Cheers
Phil
If I have a named range say of cells A1 to AD1 which can grow and shrink i.e. users can add columns anywhere in the middle, is there a way of finding the last column in the current range (i.e. given its current size).
I'd like to be able to find the column index i.e that it is column 28 for example
Cheers
Phil