From selected cell, choose a range

[jomili]

I'm getting hung up on syntax, so am asking for help. I have the following variables:

Please Login or Register  to view this content.

FirstCol is my selected column, which can be anywhere on the page, OR FirstCol is Column A (choice is up to the user)
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.

[Keebellah]

Hi would suggest you attach a file showing what you have and what you want to achieve,
this will tell more than 1000 words, the picture tells the story

[jomili]

Thanks keebellah. What I was trying to do was make a macro to color all rows that contain duplicates, in alternating colors, from either Column A to the last column, or from the column the users selects to the last column. But I was stuck, on syntax, with my old code. Since I couldn't figure it out, I trashed it and went a different route. Completed code is below, and a working model is attached.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Keebellah]

Hi, I'll check tomorrow, is past midnight here
Good-night

[Keebellah]

If I understand you correctly you're happy with his, it does the job (when sorted)

[jomili]

Actually, I'm having an issue with it. See post at https://www.excelforum.com/excel-pro...ml#post5129236

[Keebellah]

Answer/tip in the mentioned post