VBA Code for Autofill Series

Hello,

I'm trying to make a VBA code to autofill down in a series to a certain range based on other range of cells.

So example.

A1:A15 has the letter W

In cell B1 I have the number 45.

I want to auto fill down to B15 in sequential order...so B2=46, B3=47 and so on.

I don't want it to be fixed to just B15, i want it to dependent on the range of Column A.

I appreciate it in advance for any help, Just can't figure this one out.

Does this help?

Please Login or Register  to view this content.