VBA Code: Auto Filling Option

  • Hi,
    From the below code, the highlighted code is auto filling the cells from G6 to G511 and I am hardcoding the values.

    Instead of that is there anyway I can apply Ctl+Shift+Down arrow Function?


    Is there anyway same formula in G6 can be applied to the no.of cells based on data present in its adjacent column (F)

    Range("G6").Select ActiveCell.FormulaR1C1 = "=HPLNK(RC4,RC1,R1C,RC6,R2C,R3C,R4C)"
    Selection.AutoFill Destination:=Range("G6:G511")


  • Re: VBA Code: Auto Filling Option

    This should give you some ideas.

    Best Regards,
    Luke M
    "A little knowledge is a dangerous thing."

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!