Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with msgbox showing cell values
Hi,
I have vba that compares the cells in A1:A10 with the cells in B1:B10. If the value in A1 is not found in the range b1:b10 I get the error #N/ A in C1. At the end of my code I would like to display a msgbox with a prompt ("These values were not found;") and then a list of the values (the ones that caused the #N/A error in column C But I do not know how to do this. Any help is very much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to have cell values of 0 showing as blank | Excel Worksheet Functions | |||
how to create a msgbox showing progress of macro | Excel Programming | |||
MsgBox with condition and showing details | Excel Worksheet Functions | |||
Showing a Msgbox in the active application | Excel Programming | |||
Showing Search results in msgbox? | Excel Programming |