r you can.” - John Wesley
-
>
> From: StephenB
>To: excel-macros@googlegroups.com
>Sent: Friday, January 23, 2015 1:43 PM
>Subject: $$Excel-Macros$$ Re: Excel VBA remove duplicates fails depending on
>how range speci
Hi
if you want to specify range address along withh activesheet property then
you got to use activesheet.cells(r,c) syntax
since you are using activesheet.range which doesnt support you are getting
an error..
ᐧ
On Sat, Jan 24, 2015 at 12:13 AM, StephenB wrote:
> I found the answer after much g
I found the answer after much googling. I needed to remove "ActiveSheet".
myRange.RemoveDuplicates Columns:=1, Header:= _
xlNo
I'm not sure why but ...
On Friday, January 23, 2015 at 12:01:39 PM UTC-6, StephenB wrote:
>
>
>
> Hello all. First post.
>
> I'm not sure why the commented out
