If Statement in a Range

**new@this** · 03-17-2007, 05:37 PM

Is there a way to write an if statement to detect in a specific range if a certain number is within that range. And when found display a msgbox

**VBA Noob** · 03-17-2007, 06:09 PM

Hi,

This might help

Please Login or Register  to view this content.

VBA Noob

**new@this** · 03-17-2007, 07:02 PM

just say I want to find Number "2" on a worksheet and if its more than one number "2" select them all. How can I accomplish this with code.

**VBA Noob** · 03-17-2007, 07:06 PM

Try

Please Login or Register  to view this content.

**new@this** · 03-18-2007, 01:13 PM

In my program I have a Find method looking for value 1010 and its picking up other values in my worksheet like "6081110101", "1001" and "1000".

Here is the Code I have. Is there a way to match entire cell contents? for a more detail search.

Please Login or Register  to view this content.

**davesexcel** · 03-18-2007, 01:19 PM

This site may be of some help

http://www.rondebruin.nl/find.htm

**new@this** · 03-18-2007, 02:34 PM

That link helped alot!!!! Thanks!!!!!

If Statement in a Range

LinkBack

Thread Tools

Rate This Thread

Display

If Statement in a Range

Find Numbers on a WorkSheet

Find Method

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions