Fill formula down till last row in column

by

It’s a one liner actually. No need to use .Autofill

Range("M3:M" & LastRow).Formula = "=G3&"",""&L3"

More Related Contents:

  1. How can I run VBA code each time a cell gets its value changed by a formula?
  2. Concatenate column headers if value in rows below is non-blank
  3. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  4. How to avoid using Select in Excel VBA
  5. Convert Text to Date?
  6. Run Excel Macro from Outside Excel Using VBScript From Command Line
  7. Importing text file into excel sheet
  8. Loop through each cell in a range of cells when given a Range object
  9. Checking for #N/A in Excel cell from VBA code
  10. Non-web SQL Injection
  11. Error: “Could Not Find Installable ISAM”
  12. Filling any empty cells with the value above
  13. Is there a way to slow down a Web Scraper so it will pick up the code?
  14. Create a folder and sub folder in Excel VBA
  15. One-dimensional array from Excel Range
  16. Renaming Files with Excel VBA
  17. Delete cells in an Excel column when rows = 0
  18. VBA Many buttons point to the same _Click sub
  19. Sorting a dictionary by key in VBA
  20. VBA paste as values – how to
  21. What are the benefits of using Classes in VBA? [closed]
  22. Writing a VLOOKUP function in vba
  23. Generate Word Documents (in Excel VBA) from a series of Document Templates
  24. Handle cancellation of InputBox to select range
  25. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  26. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  27. VBA: How to combine two ranges on different sheets into one, to loop through
  28. Delete all data rows from an Excel table (apart from the first)
  29. Excel Hide/Show all tabs on Ribbon except custom tab
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment