rangeg2.select

Hi newbie to VBA here, I am trying to create a macro that takes a formula created in Cell G3 drags it to M3, and then auto fills to the bottom of the last row. The way I was working on it was previously recording and making some adjustments, I cannot find a way to have it auto fill to the last...

Hi everyone, im trying to Autofill rows within a column with a formula and im using this : Range("G2").Select ActiveCell.FormulaR1C1 = "=LEFT(H2,10)" Columns("G:G").Select Range("G2").Select Selection.AutoFill Destination:=Range("G" & Rows.Count).End(xlUp) And i get the error...

Hi. I am using macro to search for a cell with "Exchange", insert a column on its left and use vlookup. Everything works fine when "Exchange" is in Column G. I want to change the macro so the Selection.AutoFill autofills the Vlookup functions in the inserted Column even when the "Exchange"...