Emoncada
05-08-2012, 11:34 AM
I have a spreadsheet with multiple column headers.
I have Column A with a Combobox that has a list of all headers.
I also have frozen panels so Column A and Row 1 always are showing.
I would like for when I select a header name from the combobox for the column next to A move to that column.
So If I select Desktops from the Combobox and Desktops header is in Column H then I will see Column A then H next to it.
I know you can use something like this
ActiveWindow.SmallScroll ToRight:=5
But the problem with that is it moves over from where it is at that moment not from Column B.
Any suggestions?
I have Column A with a Combobox that has a list of all headers.
I also have frozen panels so Column A and Row 1 always are showing.
I would like for when I select a header name from the combobox for the column next to A move to that column.
So If I select Desktops from the Combobox and Desktops header is in Column H then I will see Column A then H next to it.
I know you can use something like this
ActiveWindow.SmallScroll ToRight:=5
But the problem with that is it moves over from where it is at that moment not from Column B.
Any suggestions?