selection.autofill

I pretty much recorded a macro and have decided that because of my lack of VBA skills, this would be the easiest route. However I have 2 problems with this. My range selection for VLOOKUP is not static and will change, thus I need to come up with a way to select all the same columns, but the...

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"...

Hi, Below is my code, is there anyone who can help optimize this? Sub filtering() ' ' filtering Macro ' Dim Rng1 As Range, Rng2 As Range Dim ws1 As Worksheet, ws2 As Worksheet, ws3 As Worksheet Dim src As Range Set ws1 = ThisWorkbook.Sheets("eodcpos") Set ws2 =...

How do I edit this to copy the contents in cells P2 and Q2 the last row of data in both columns P & Q? I know where my problem below...I just don't know how to fix it. Thanks Range("p2").Select ActiveCell.FormulaR1C1 = "=IFERROR(VLOOKUP(RC[-13],Collector,3,FALSE),"" "")"...

<tbody> 1 2 3 4 5 6 .... 31 a b c d e f ... k </tbody> I would like to shorten the following vba codes. Any good suggestion? Thanks. ActiveCell.Offset(42, 0).Range("A1").Select...

I am having trouble getting the above code to work. I am trying to run a selection autofill macro for two different variables that are stored ranges and am running into errors. Any help would be amazing! :confused: Sub Automation_BOBJ() Dim startPointBobjGL As Range Dim...