Additional Line of Code Needed

Hi,

I am using this macro to populate certain cells based on the length of column B. So far it does it for Columns D to H. What code do I need to add so it will populate column A with the formula in A2? I have attached a spreadsheet to hopefully make what I'm after clearer. Please refer to the Output tab to see what I intend the macro to do.

Thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

?

ahhh...i was writing:

Please Login or Register  to view this content.

thanks!

And for the code below, this populates cells based on the length of column B also. How do I change it so it will drag the formula in A5 to reach the same length as column b is? Thanks

Please note this does not refer to the attachment in my previous post.

Please Login or Register  to view this content.

Does anyone know the line of code I need for my post above?

Thanks