VBA to Filldown Every Other Column with Formula

[msawyer]

The code below should enter a formula beginning in column O (15th column) followed by every other column until the 93rd column on the "Winshuttle" worksheet. Instead, the code is starting on column S or V. How do I get this to start in the 15th column?

Please Login or Register  to view this content.

Please see attached for example.

[Norie]

The code isn't starting on column S or V, it starts on column O then moves to Q, then R and so on until it finishes in column CO, the 93rd column.

Mind you I don't think the formula is quite right.

In column O you have this,

Please Login or Register  to view this content.

where the column index is 9.5.

[msawyer]

When I run the code, it starts in column S. It is supposed to start in column O but isn't.

[Norie]

When I run the code it starts in column O.

You can see that in the Immediate Window (CTRL+G) if you add this just after the For.

Please Login or Register  to view this content.

[msawyer]

I figured it out. I forgot about a hidden column I had on the Template page. Thanks for the help.