Macro scrolls columns too far, some colums are hidden.

[JCMus]

Hello. I have a macro that scrolls to certain columns. It works fine as long as some of the columns are not hidden. Sometimes it is neccessary for columns to be hidden. When some columns are hidden, it scrolls too far. It appears that my present macro doesn't count the columns which are hidden.

....
ActiveWindow.ScrollColumn = 50
....

When I check the column # with =column(), the column # returned is 120 (there's lots of hidden columns). Is there another way to do this so it scrolls to the right column? I need something that will work whether the columns are hidden or not.

Much appreciated,
JCMus

[rylo]

Hi

If you know the column that you want, then select that column directly. Do you know exactly which column you want? Also, do you have a particular cell in the column that you want to be in the top left of the screen?

rylo

[JCMus]

What is the code to select a column direct if the column is DA?

Thanks
JCMus

[rylo]

Hi

Please Login or Register  to view this content.

This will select DA1. Now where it is on the screen is another matter...

rylo