Want to copy formula from G7 to blank cells

[HaroonSid]

hello
i need to change below formula

i want to copy formula form G7 to last blank cell of column G
while below code copy formula g7:g100

Please Login or Register  to view this content.

[protonLeah]

deleted, ?? last blank cell ??

[sktneer]

May be this.......

Please Login or Register  to view this content.

Here lr will be the last non empty row in column G.

[HaroonSid]

Hello ProtonLeah

Last Blnk Cell ??

i mean if D7:D15 are blank and D16:D50 Has formula

then Formula Fill D7:D15 not overwrite to D16:D

[HaroonSid]

Hello sktneer

works perfect thanx alot

will add +1 repu