#5 Invalid procedure call or argument

[bobkap]

I cannot get past this line of code. I keep getting this invalid message. If I just use something like "Range("$A$1:$h$20")" I don't get the error and the macro runs fine. But, I want to use variables as my range is going to vary every time this macro is run. Any help would be greatly appreciated.

Range(Cells(1, 1), Cells(finalrow, finalcol)).RemoveDuplicates Columns:=Array(email, courseyear), Header:=xlYes

 

[Fluff]

Cross posted https://www.myonlinetraininghub.com/excel-forum/vba-macros/variables-do-not-work

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

 

[bobkap]

Cross posted https://www.myonlinetraininghub.com/excel-forum/vba-macros/variables-do-not-work

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

I had no idea that anyone was still reacting to my posts. I have been a fan and follower of Bill Jelen for years now. It is never my intent to violate anyone's policies. Rather, I assumed one source was finished so I contacted my friends at My Online Training Hub and they asked me to post my questions on their site.

Never did I have any harm intended. I'm a "rule follower" to an extreme.

 

[Fluff]

I had no idea that anyone was still reacting to my posts.

We were just waiting for you to answer the questions asked & had no way of knowing you had decided to ignore us & post the same question elsewhere.

 

[bobkap]

We were just waiting for you to answer the questions asked & had no way of knowing you had decided to ignore us & post the same question elsewhere.

I NEVER ignore the responses I get here. I tried all of them with no success.

 

[Fluff]

From post#10

What are the variables email and courseyear showing?

 

[bobkap]

I'm tied up in meetings all day and I'm on Pacific time and not able to look at the moment. I will let you know as soon as I can.

 

[Fluff]

Ok, no problem.

 

[Fluff]

For the record, judging by your file on the other site, the problem is that finalcol is 7 but courseyear is 8.
You need to recalculate the final column.

 

[bobkap]

Thanks!