Inserting 0 in selected cells in excel

[Byrner]

Hello , A very warm Hello or Hi to everybody from Ireland

I have just joined my name is Maureen, Not great on computers but using excel for a small craft business I am trying to get going.
Can anybody help? I need to insert the number 0 in selected cells , is there a quicker way to do this other then by typing in 0 opposite every selected name?
I have a long list of customer names, if one name on the list e has order from me in the past I need to insert 0 in the column beside their name.
Its an old list, so I have to read from the list and and when a name matches insert the 0
Any help would be really great
Thanks again
Maureen

 

[Fluff]

Simply make this change

If Intersect(Target, Range("G:[COLOR=#ff0000]U[/COLOR]")) Is Nothing Then Exit Sub

 

[Byrner]

Try changing the "I" to a "U" in the line below:-

Intersect(Target, Range("G:I"))

Hi, That works
Thanks again

 

[Byrner]

Just to say Thank You to all who replied
Everything working now , really impressed with this forum
Thanks again to all, especially Fluff and Mick
Maureen

 

[Fluff]

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1231321-double-click-to-insert-a-number.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Byrner]

Hi ,
I take your point and In am sorry about that. Its just I was up all night working on this, it was driving me up the wall, I taught that no one might use this site as it was saturday so that' s why I tried to find an answer elsewhere. Really sorry about that it wont happen again I will try and delete other post
Regards
Maureen