Excel VBA - If Statement

For God's shake... I was hoping you will show us how to correct this and check always the price and not only once... what is the purpose of this video ? to show us just that "if" statement" is incomplete ?

What to do if i want to copy the data to different sheets ???

Sir, You have any idea how to correct this code.
I am trying to When i entered Cell e Value is (=Whatsapp Group) then Cell K value is show as 1 and this can be done automatic to last available data Row.

If Range("e3:e" & lastrow).Value = "Whatsapp Group" Then Range("k3:K" & lastrow).Value = 1

When i apply this formula the error show "run time error 13 Type mismatch"

Sir mine is showing eror no. 75?

*Nice* Thanks a Lot.

Thank you, it`s really good tutorials

Nicely explained. Thank you very much

Sir How to prevent sheet tab names means user can't change sheet name ?

you are great sir..

I want date in a cell is changed as next date when click a command bottom, please give me the code!