On 12 Mar, 20:53, Resi wrote:
sorry when i run the macro in excel the error says:
compile error:
invalid inside procedure.

of any help?
tahnks, Resi




Sorry, but I am out of town and won`t be able to respond for another
week or two.

Be sure, before you paste anything into the window that opened when
you right-clicked the appropriate sheet tab, that the window is empty.

Also, be sure that the worksheet references within the macro
correspond to your worksheet names. In your original posting, I
believe you called them sheet 1 and sheet 2. But subsequently you
referred to one of them as "B". This obviously makes a difference.

I won´t be able to do more until I´m back home.