I have an event macro that puts data into columns AB&C if criteria in N matches requirement. I need to prevent that code from running if the cell in column b already contains data
ThanksPlease Login or Register to view this content.
I have an event macro that puts data into columns AB&C if criteria in N matches requirement. I need to prevent that code from running if the cell in column b already contains data
ThanksPlease Login or Register to view this content.
if Target.Offset(0, -13).valiue <>"" then exit sub
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
@nathansav
may be -12 and use code tags for code posting?
Try this
Cheers!!Please Login or Register to view this content.
Last edited by excelliot; 06-16-2014 at 04:35 AM.
Thanks Excelliot, quick and so simple a solution, if you know how
Thanks
Cheers!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks