error message "match not found for row "

**jazbath** · 04-20-2009, 04:33 PM

Hi,
I am attaching my workbook. On sheet1 it has data and on sheet2 I have buttons to run macro. The macro brings in the data I want but after editing it does not put it back. The message it gives is "match not found for row".
Appreciate your help on this please.
Thank you
Jaz

**JBeaucaire** · 04-20-2009, 04:55 PM

Try changing:

Please Login or Register  to view this content.

**JBeaucaire** · 04-20-2009, 05:10 PM

Other things:

Right-click on your buttons, format control, Properties...click on Do No Move or Size with cells
You should get in the habit of declaring your variables at the top of your macro...add them there as you add them into the macro
Any "ranges" you set during the macro should be set to = Nothing at the end to free up the memory Excel reserved for it
Your FIND macro didn't have an EXIT capability...so I added it.

Please Login or Register  to view this content.

**shg** · 04-20-2009, 05:16 PM

Here's my cut at cleaning up your code. Note the first line.

Please Login or Register  to view this content.

**jazbath** · 04-20-2009, 05:44 PM

JBeaucaire & Shg,

Thank you guys for your help. I know I need to learn a lot still and also to clean up my code. I am trying.
Shg I will remember about the title hereafter.

Jaz