Afternoon, I have some code i just want to expand. Currently the macro runs through a large sheet and checks the first column for duplicates is a duplicate it clears the following dup-value in that column. I want now clear the row instead of just that cell. Any ideas on how to accomplish this task?????? My code provided below.
Please Login or Register to view this content.
Last edited by VBA Noob; 07-16-2008 at 03:35 PM.
Change ".Clear" to ".EntireRow.Clear"
Please Login or Register to view this content.
Regards
Rick
Win10, Office 365
Rick,
Thanks for the help!! Is there a refrence point of all the object/ refrence Library available for VBA? Thanks again!!
I hoenstly don't know. I only knew this answer because I was doing a similar task.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks