Add "Dim lr as Long" to the macro as I take it you have (correctly) an
"Option explicit" statement in you code.

HTH

"countryfan_nt" wrote:


Thanks,

But, When I run the code I get "Compile error: Varriable not defined".
And "lr =" is highlighted. What Am I missing? Or what did I do wrong?

Nawaf


--
countryfan_nt
------------------------------------------------------------------------
countryfan_nt's Profile: http://www.excelforum.com/member.php...o&userid=11051
View this thread: http://www.excelforum.com/showthread...hreadid=386366