Creating a macro to generate a list for hundreds of rows

Hi -

I'm trying to create a macro that will create a list for hundreds of rows. I created the first portion of the macro, however needing help on how to apply from rows 6-462. Please note each row has specific selection options.

Please Login or Register  to view this content.

As you can see cell D5, needs to have the list options of AU5:AX5. Looking on how to carry this down to D462 with the list option of AU462:AX462. Any help is greatly appreciated.

Hi kcgojnur,

Try the following Macro. Changes in red. In most cases 'Select' is not needed, and causes Macros to run slowly.

Please Login or Register  to view this content.

Lewis