Autofill using VBA Code - Autofill Formula down

This Excel VBA Tutorial Explains how to autofill down to last row.
We can use VBA Code to Autofill dynamic range. Also, we can autofill formula to last row.

[@JavierSanzGarcía-b8z]

Danya Vaat for the explanation!! I only needed to use the "last_row" as string and then substitute it on my Macro that I recorded. Have a lovely day.

[@BartFlossom]

I can't wait to try this. It seems much cleaner than my clumsy macro.

[@revathijothi5723]

Thank you so much. i have tried to write vba code using "Length Substitute" Formula. i completed with the help of your video

[@ExcelDestination]

Glad it helped!

[@preethisuryanarayanan6858]

Thank you, this video was very useful.

[@santilvaromola7669]

finally what I was looking for! thanks!!

[@ExcelDestination]

Glad I could help!

[@luisalanmendozaalvarez5264]

Thank you from Mexico

[@leonardoguerrero1539]

A great code and good explanation thanks for sharing it

[@ExcelDestination]

You're welcome!

[@SMEEST55]

Also : select the range, type =a61*b61 in formula bar, press control+enter: the adjusted formulae are filled in the whole range

[@manishdagli1547]

❤ great explanation. Can you make one more video with fanatic name of the workbook. Let me explain, I need to switch between two windows, one is sharepoint file and the other is the shared file. I have to delete old data of the sharepoint worksheet, then copy data from the shared file and paste it at sharepoint file using vba. Please make it asap. Thanks

[@milindshiralkar6284]

very nice!

[@1403chocolate]

thank you so much for this valuable sharing. I want to know how can i make my_range to be dynamic instead of setting it to E? I have a table from column G ~ X where i want to have =sum() at the end of the row. how can i set this to be dynamic?

[@atifatoz3415]

Video is Excellent but I have a question.If I want to add other data just under the first data then How can I make a new dynamic range on last row ?...I am talking about two table just back to back

[@pandharinathjoshi6565]

Sir nice video. Sir if i convert Table format the formula will work continuously running total for click option sir

[@alializadeh8195]

مرسی

[@chakra1siva195]

Hi, how to do If we need to do this same for multiple columns....

[@ALEXSHUNCAI]

Great Video! I was wondering is it possible to enter the formula of E2 in VBA code as well, then pastespeical? and that way, you don't have to manually enter the code into the worksheet first, then executing the code? thanks!!!

[@ASI15236]

Sir - informative video. I am not clear on the last two statements. "Worksheets("Sheet1").Cells(1,1).Select , why is this necessary and "Application.CutCopyMode = False" , why and what does it do? Thanks

[@Grog_Alvaro]

Hola que pasa cuando aumentan mis registro??

[@jay55patel]

thank you

[@ExcelDestination]

Welcome!

[@amarkardile7185]

How to make first row and last row dynamic for changa dates

[@RobertLongM]

How can we make this dynamic - where when Once cell A# is not null, that the formula then is carried down? Basically - How can we mimic a Table in Excel when you add a new row, it will copy down any formula.

[@ExcelDestination]

I would suggest to write to use same code in event programming. May be on Selection Change event or Workbook Open Event. I would upload next tutorial on Event Programming Soon to run macro automatically.

[@RobertLongM]

@@ExcelDestination thank you I found in the script source in the menu for Tigger schedule. Also I found the getsheetByName syntax

[@debojyotidebnath4703]

Hi, I am getting runtime error "1004 pastespecial method of range class failed" kindly help

[@wibukere24]

Can you make it for dates?

[@ExcelDestination]

I hope it should work with dates also.

[@MrWmo1975]

Hello, thank you for this very useful clip. Could you please help me write the vba code for auto-filling multiple cells on the same row (not in sequence) if a specific value (e.g. operator) is selected from a cell on the same row in column B. I do not want to use formulae to auto-fill those cells as values can be variable and usually free typed depending on what's selected from the cell on the same row in columns B. Also, can the macro be called when a selection is made from column B? Hope you can help and thanks in advance.

[@nabajyotisarkar7418]

I have marge cell how can do this

[@ExcelDestination]

I think Autofill formula doesn't work in merged cell. But, let me research, if there is a way to do this.

[@hemantgoyal409]

Sir please help with the vba code to split text from this kind of data..ex R100 Hp100 Nba100 etc

[@ExcelDestination]

Sorry sir ab vima ji nahi rahe

[@hemantgoyal409]

Oh..very sorry to here ..kaise

[@ExcelDestination]

Heart attack

[@hemantgoyal409]

@@ExcelDestination My condolence to sir..may his soul rest in peace..if possible to send his picture..I want to keep him always in my memory..as he helped me a lot through his videos..

[@ExcelDestination]

Sir aap mail kar do mai pics send kar dungi

[@karmusinghsiddhu190]

can pls help me on this formulas. its not work, Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Range("A1") "" Then Range("A1").Select Selection.AutoFill _ Destination:=Range("A1:A5"), Type:=xlFillDefault '.Range("K5").Formula = "=IF(AND(F5="",G5="",H5=""),"",(I4+F5-G5-H5))" End If End Sub

[@fral.2708]

Play at x1.25 reproduction-speed to stop the ASMR-effect...

[@vijaykaushik7524]

7:48 you have told the wrong coding. after creating dynaming range and set my_range ,you need to type range("E2:E"&last_row).select only after that dynamic range will be selected. don't teach false information. i had to think a lot about this why this coding was not working for me. you have provided wrong coding.

[@sonalikarna7136]

It is showing error 438

[@ExcelDestination]

without looking at code, it is difficult to say anything.

[@aries6776]

This is out of date now and doesn't work.

[@manojk2890]

Not interested