try to Copy entire Row if active cell equals variable

Originally Posted by Mfederman

You are awesome. I REALLY appreciate you taking the time to put this together!
I just copied and pasted the code in to a new module and tried to step through and got a new error:

"Run-time error '6': Overflow"

I'm not sure what that means.

The line that gets highlighted when I hit debug is

for i = 2 To lRow

"

Yep, sorry...Need to declare i As a Double and not Integer
So

Dim I As Integer

must be

Dim i As Double

EDIT: But seriously go with my second code...Post # 13 Works much better.