Ok, this may be a quick question or it may not be. I am trying to make a macro that will auto fill three forumlas down. It can go anywhere from 5 rows to 5,000. I am in no way a pro or even an amateur in VB so any help would be appreciated. The excel spreadsheet looks something like this:

A B C D E F
1 1.20 1.50 1.66 frml frml frml
2 1.23 1.45 1.77
3 1.45 1.55 1.88
4
5

I hope that kind of makes sense of how i am trying to get them to auto fill down. I know how to get it to work if i know the exact range i want to fill but not a variable range depending on how much data has been added.

::EDIT:: upon submitting i see my arranging of my "mock up" of the spreadsheet is all out of wack and i cant seem to get it to look right.

Quote: Originally Posted by Reverend KWR Ok, this may be a quick question or it may not be. I am trying to make a macro that will auto fill three forumlas down. It can go anywhere from 5 rows to 5,000. I am in no way a pro or even an amateur in VB so any help would be appreciated. The excel spreadsheet looks something like this: A B C D E F 1 1.20 1.50 1.66 frml frml frml 2 1.23 1.45 1.77 3 1.45 1.55 1.88 4 5 I hope that kind of makes sense of how i am trying to get them to auto fill down. I know how to get it to work if i know the exact range i want to fill but not a variable range depending on how much data has been added. ::EDIT:: upon submitting i see my arranging of my "mock up" of the spreadsheet is all out of wack and i cant seem to get it to look right.

How is the data going to be added? There's a couple of ways to do it, but if you want it to autopopulate the formula as the data is added, it's a bit trickier versus just putting in the data then running thru a macro to finish up.

I was sitting there and when i stopped looking it it for a while i had a great idea on how to solve the problem, went back, looked over it again and got it to work. It works for what i need it to do now. Just now got to a computer to update.