VBA Vlookup Filldown/Autofill in Alternating Columns

[msawyer]

SizeFillDownExample.xlsI am trying to write code to fill down a column with a vlookup formula for every other column beginning in column N and ending in column CN. (please see attachment for layout).

Example: The lookup formula would be entered in columns N, P, R, ..., CN
In the lookup formula, the column index number would need to increase by 1 in each column
Column Index for column N = 18, Column Index for column P = 19, Column Index for column R = 20, etc...

Here is the code I have so far.
Attachment 224430

Please Login or Register  to view this content.

Any help is greatly appreciated. Let me know if I need to clarify anything.

[AlphaFrog]

What's the point of supplying an example workbook that doesn't have your code, or a worksheet named "Winshuttle" or a named range called "MaterialData", or an example of the end result you're looking to achieve?

[msawyer]

I have updated the example workbook.

[AlphaFrog]

Please Login or Register  to view this content.