I need to copy a function down a column to length of the adjoining column to the left. I recorded a macro which did what I wanted. Unfortunately, the column changes sizes depending on my data. Unfortunately, every time I run the macro it uses the length that was recorded the first time. How can I set up a dim or something to have the autofill work with the variable length lists

Thank you very much for any help


Re: autofill vba code

Bruno Yu - MSFT

Move the thread from Visual Basic General. There are more exports on VBA in this forum. I believe you are able to get more satisfying answers in this forum on the VBA problem.

Thanks again for your question.