Trouble using a variable range for removing duplicates.

[FZappa]

Hi all, I'm sure this is just me not understanding the kind of variable I'm using, but here is my code

Please Login or Register  to view this content.

My issue is with the last step of the code. I've tried using ActiveSheet.Range(rango) as well as ActiveSheet.Range(Selection) but it tells me that it's an application-defined or object-defined error. I suspect that I'm either not defining the object appropriately, or I'm not using the correct syntax when trying to use that range to remove duplicates. Am I on the right track or am I going about this in the complete wrong direction? Thanks in advance.

[TMS]

Probably just

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[FZappa]

Thanks for the advice. I've made the changes as requested.

[TMS]

You're welcome. Thanks for adding the code tags.

Did the suggested amendment work for you?



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[FZappa]

Right, I've tried implementing your solution

Please Login or Register  to view this content.

but now the error it gives me is 438: Object doesn't support this property or method

[TMS]

Try:

Please Login or Register  to view this content.

[FZappa]

Hi, sorry for the delayed reply. That definitely worked, thanks!

[TMS]

You're welcome. Thanks for the rep.