VBA - Deduplicate a column without exact references

[rachel06]

Hi!

This is probably another easy one, but again, nothing I'm searching for is helping.

I want to remove duplicates from a column but I don't want it to have exact cell references. It's going to be a different number of rows for each dataset each time.

Everything I've tried either slows the macro way down, completely crashes excel, or crashes the macro.

This little bit is part of a larger code. My data starts in cell E1:

Columns("E:E").Select
    ActiveSheet.Range("$E$2:$E$28605").RemoveDuplicates Columns:=1, Header:=xlNo

I know this is super simple and super basic and I feel so silly that I can't figure it out. Hoping there's an easy fix to update!

 

[Joe4]

I made the edit right after you copied me to point it out.

My mistake. I was looking at post 7, and mistook the "quote" there as your updated "code"!
I didn't see that you had updated the original post.