Modifying an Excel sort macro

[Kathy Belvel]

I hope someone can help me with a mismatch error I am getting in a sort routine that I have modified to by changing to R1C!. I needed to change the to r1c1 since the table being sorted changes form week to week causing several cell references to change. The error (Run-time error 13 - type mismatch) occurs on the following line of code (line 20 in the image below);

.SetRange Range(Cells(r2, c), Cells(r3, c2)).Select

Below is a screen shot of the subject section of code. I suspect I will get the same error on line 36 when that condition is met.

Thanks in advance,

Kathy

 

[MARK858]

Try removing the

 .Select

Also just for your info, on your Dim line every variable bar c2 is being declared as Variant not Integer

 

[Kathy Belvel]

Thanks. it worked. I'm really embarrassed, I should have caught that all by myself. I guess I was looking at it too long.

Kathy

 

[MARK858]

You're welcome