Macro coming back with Run Time Error

[amasulli]

Hi Guys,

I'm getting a run time error when I run the Macro below. Fortunately, the Macro still works but it comes back with the error. Do you guys see any reasons why this is happening? The error is the following:

"Run-time error '1004': The command could not be completed by using the range specified. Select a single cell within the range and try the command again."

It's definitely something to do with the auto filter but I don't understand what it is...

Please Login or Register  to view this content.

[MarvinP]

Hi amasulli,

Put a breakpoint in your code and single step through it. Find the line that gives the error and hover your mouse over the variables on that line. I'd bet you have LR =0 or something like that which gives an invalid range. See http://www.cpearson.com/excel/Debug.htm for how to solve your own problem.