Excel VBA Dynamic Autofill

[mathsbeauty]

The Column has entries as shown below.

AA

BB

CC

I want to auto fill entries like all cells in the column between AA and BB get auto filled by AA, all cells in the column between BB and CC get auto filled by BB and so on. This should continue till the end of last row. Any help will be appreciated.

 

[footoo]

Assuming that cells are in column A and"AA" is in A1 :
• Select column A
• Go to SpecialCells/Blanks
• Type =A1
• Press Ctrl+Enter

 

[mathsbeauty]

This does not work. Probably you misunderstood. Please find attached solution. Also I prefer to have VBA Solution.

 

[MARK858]

Are your blank cells truly blank and not with formulas in them? (BTW I would use = and press the up arrow rather than =A1 as it is more generic).
We will worry about the VBA once we have sorted out why it isn't working manually.

 

[Peter_SSs]

One more question: You have shown "CC" filled down from row 18 to row 23. How do we determine where the last value should be filled to? From what we can see, there is nothing else on the sheet that would indicate the final row.