Autofill a Dynamic Selection

[georgeanaprop]

Hi

I have looked around quite a bit and am looking for a way to fill down a pre-selected range of cells down until the last row that is defined by column A
The most common type of autofill solution is as stated below, but that is not what I am looking for. It needs to autofill based on the cells that are currently selected (it can be one cell, three cells etc...).

Please Login or Register  to view this content.

However, the problem is that it is defined by autofilling from A1:C25 (as an example), but the cells that need be autofilled may not always be in columns A:C

I am using the following code. It does the job but it is not efficient. I would like to take out the last two lines and just use the "Selection.AutoFill Destination:=Range(Selection, Selection.End(xlDown)), Type:=xlFillDefault" to take down to correct line (and not the end of the sheet as is currently doing

Assume that cells are pre-selected or highlighted before running the macro.

In my attachment, I have selected the last cells in columns E:C for ease

Please Login or Register  to view this content.

View my attachment as an example

Thanks in advance for the help

[royUK]

please use Code Tags not HTML Tags

[foxguy]

Hi georgeanaprop;

Here's what you want

Please Login or Register  to view this content.

[georgeanaprop]

Foxguy, that worked very well

Thank You

[foxguy]

You're Welcome.

[razam15]

There has to be an easier way to do that. That's way too many steps for a simple fill down. Can someone please chime in. Thanks!

[arlu1201]

Razam15,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.