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?


    or


    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")
    Range("G6:G511").Select


    Regards,
    Sri

  • 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!