I'm getting hung up on syntax, so am asking for help. I have the following variables:FirstCol is my selected column, which can be anywhere on the page, OR FirstCol is Column A (choice is up to the user)Please Login or Register to view this content.
LastCol is the last populated column on the activesheet
In my selected column, I'm stepping down through the cells to determine which cells are duplicates, to color those with alternating bands of color. My code below works great for the selected column, but I want to color the range from FirstCol to LastCol within the rows currently selected by the macro, and can't figure out how to phrase that. Your help is greatly appreciated.Please Login or Register to view this content.
Bookmarks