Скачать или смотреть VBA Macro: Add Formula and Drag to Last Row

Learn how to create a VBA macro to add a formula to a specific cell and then drag it to the last row of the adjacent column!

Here's the code for you to customize for your own project:

Sub Insert_Formula_and_Drag()
'Inserts vlookup values into column D
Dim LastRow As Long
LastRow = Range("C" & Rows.Count).End(xlUp).Row
Range("D2").Formula = "=vlookup(C2,A:B,2,FALSE)"
Range("D2").AutoFill Destination:=Range("D2:D" & LastRow)
End Sub

Please support my fledgling channel by subscribing! I will show you quick tips related to RPA tools, primarily MS Power Automate, UiPath StudioX, and Visual Basic!

Check out my other videos here: https://www.youtube.com/@jibbsautomat...

Intro to Power Automate Cloud Flow series:    • Intro to Power Automate Cloud Flows  

Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden
My website: https://www.jeremybarden.com/

#excelmacro #visualbasic #rpa #lowcode #excelformula