Delete rows - use variables in array stmt?

[bobkap]

I need to remove duplicates when columns 3 and 8 match. This line works fine:
Range(Cells(2, 1), Cells(finalrow, finalcol)).RemoveDuplicates Columns:=Array(3, 8), Header:=xlYes

But, I prefer to use variables of course. I've tried as below by replacing the 3 and 8 with a variable but it always bombs out. Even though it made no sense. I even tried putting quotes on the variables but still no dice.
Range(Cells(2, 1), Cells(finalrow, finalcol)).RemoveDuplicates Columns:=Array(email, yearbk), Header:=xlYes

Is there no way to use variables this way?

Any help is most appreciated.

 

[mehidy1437]

Please post the code or part of the code, so someone can see & work on.

What is the declared data type of email & yearbk?

 

[bobkap]

Thanks. After some trial and error I was able to get that to work. BUT, another problem - This keeps getting an error that this line "yearnum = year(curdate)" expects an array?? I thought I had syntax correct but I guess not. Might you have a suggestion please?

'Extract year only from course date
cordate = Application.match("Course Date", Range("1:1"), 0)
finalrow = Cells(Rows.Count, 1).End(xlUp).Row
For counter2 = 2 To finalrow
curdate = Cells(counter2, cordate)
yearnum = year(curdate)
Cells(counter2, courseyear) = yearnum
Next counter2

 

[mehidy1437]

I'm sorry.
Hope some experts will look into this & have a solution for you.