Dont trigger code if -1 column of target column has already value Worksheet change event

[HaroonSid]

hi,
i am using this code to add some formulas when i input data in range f10:f1000
if cells(Target.Row, "E") has already formula or value then don't trigger this code

thank you

Please Login or Register  to view this content.

i mean trigger only one time when i put value in range f10:f1000

for example
i input some data in range f10
then this will add this formula to

a10= formula
b10= formula
c10= formula
d10= formula
e10= formula

and again i type some data in f10
now dont trigger the code because a10, b10, c10.....ae10 have already formulas

thank

[jindon]

When you write a code in Worksheet_Change event and change the value, it is always better to enabelevents set to false/true, otherwise unnecessary event is called.

Please Login or Register  to view this content.

[HaroonSid]

Again super perfect

thank you Jindon Guru Ji

you made my day

will it work if If target has value only not formula or need to change code

thank you

[HaroonSid]

Can't add reputation too you

Capture.JPG

[jindon]

will it work if If target has value only not formula or need to change code

What do you mean?

[YasserKhalil]

Can't add reputation too you

Attachment 526324

You have to add reputation to someone else first then you can add reputation to Jindon again after refreshing the page