VBA Find statement not working

[yusunghee]

Hi Guys,

I am having problems with the find statement in vba.

I have one sheet, called "Summary", where it lists several categories like "Revenue, items sold, gross profit, etc. Each item is assigned a specific number in the column to the left.

I have another sheet. It's an income statement. It also has specific numbers listed in column a, which corresponds to the revenue and expense line-items.

I created this macro in which the macro pulls the item number located in teh summary page and finds teh corresponding data from the income statement. however, when I run the macro, the find statement doesnt find anything. The strange thing is that, the macro has run successfully before. I don't know why it won't work now.

Below is part of the code. Please help. Thanks

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Very difficult to diagnose without seeing your problem in the context of its workbook. Please upload.

Thereagain are you sure a VBA macro is the most efficient way of achieving what you want. It's possible that standard Excel functions would suffice and be better.

Regards