Im looking for code to perform the following:
If text in F6 down to last cell equals 'Barcode Only Mode', then erase the formula for that cell but keep the text (or just erase it and then enter 'Barcode Only Mode' if thats easier, same thing).
Im looking for code to perform the following:
If text in F6 down to last cell equals 'Barcode Only Mode', then erase the formula for that cell but keep the text (or just erase it and then enter 'Barcode Only Mode' if thats easier, same thing).
Please Login or Register to view this content.
ikboy that just removes the formula for all cells in the range.
How about this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
That code doesn't seem to do anything I can see. No errors.
Hello Nitefox,
Try this version:-
I hope that this helps.Please Login or Register to view this content.
Cheerio,
vcoolio.
Last edited by vcoolio; 07-15-2018 at 10:59 PM. Reason: Typos
Thanks vcoolio that worked great.
You're welcome Nitefox.
I'm glad that I was able to help.
Cheerio,
vcoolio.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks