Excel macro to take action when find doesn't return anything

guilhermelemos

New Member
Joined
Oct 7, 2013
Messages
11
Hi,

I am working on a longer macro, which will fill some fields depending on a few data sources.

Where I am stuck is when the code looks for some information in a report, but doesn't find (that is expected in a significant number of instances).

I need the macro to tell me (actually to take action, re-start a loop based on slightly different info) when that initial information the code was looking for cannot be found.

The relevant section of the code:

Application.Goto ActiveWorkbook.Sheets("Inventory").Cells(1, 1)

Set Found = Sheets("Inventory").Cells.Find(What:=k, _
LookIn:=xlValues, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False).Activate


When the find function is successful, the code leaves me at the cell where the content was found. When the content is not found, it just doesn't go anywhere and no "alert" is generated.

Thanks in advance.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,224,558
Messages
6,179,512
Members
452,919
Latest member
krismmmitch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top