LinkBack URL
About LinkBacks
Hi,
great.
Actually, I would like the entire row to clear the contents please.
So something like range (cells 1) to ( cells 60) . Value = ""
possible?
Hi,
great.
Actually, I would like the entire row to clear the contents please.
So something like range (cells 1) to ( cells 60) . Value = ""
possible?
Clear cell contents if the next value you enter in col a has a duplicate.
Only checking column a please.
I had already modified the code to delete the entire row. You can have it delete from cells 1- 60 , but that will leave a blank row?Originally Posted by Lifeseeker
I don't understand what you are saying in this sentence?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
oh I see..
hmm maybe deleting the entire row is a better option. I will check it tomorrow.
Thank you
@ JapanDave,
Your Code works Fine! I tried to tweak it to only Clear the Range found with duplicates, but it does'nt work?
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks