Dynamic Autofill

**ejoneslor** · 11-11-2015, 10:44 AM

I'm pretty new to VBA programming and need some help with a dynamic autofill please.

I have a spreadsheet that pulls in a dataset from a database which is similar to the area highlighted yellow on the attached mock up.

Once this dataset is in my workbook I want to autofill a simple formula against each line. I've done this for the example attached with the Macro 'FillFormula'.

My issue is that the size of the dataset can vary depending on some conditions and so the number of rows of data is dynamic. How do I edit my code so that the autofill always starts at cell D1 and keeps going until it hits a blank cell in column A then stops?

Any and all help appreciated.

Ed

VBA Example.xlsm

**sktneer** · 11-11-2015, 10:50 AM

Try this.....

Sub InsertFormula()
Dim lr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
Range("D1:D" & lr).Formula = "=IF(C1="""",""x"",C1-B1)"
End Sub

**davesexcel** · 11-11-2015, 10:52 AM

Sub FillFormula()
    Dim rws As Long, rng As Range

    rws = Cells(Rows.Count, "A").End(xlUp).Row
    Set rng = Range("D1:D" & rws)

    rng = "=IF(RC[-1]="""",""x"",RC[-1]-RC[-2])"

End Sub

Checkout AutoFill Macro On YouTube

**ejoneslor** · 11-11-2015, 11:38 AM

sktneer, davesexcel,

Problem solved, Thank you.

Ed

**sktneer** · 11-11-2015, 12:06 PM

You're welcome Ed! Glad we could help.

Dynamic Autofill

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Dynamic Autofill

Re: Dynamic Autofill

Re: Dynamic Autofill

Re: Dynamic Autofill

Re: Dynamic Autofill

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] AutoFill down dynamic range

[SOLVED] Autofill help with dynamic data

Dynamic Autofill

Need help with dynamic autofill

Autofill a Dynamic Selection

[SOLVED] Dynamic autofill VBA

[SOLVED] autofill with dynamic lists

Bookmarks

Bookmarks

Posting Permissions