View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luc Luc is offline
external usenet poster
 
Posts: 23
Default How to check if a range contains a certain value

Hello,

A newbie question

I have a range named GRID (3 columns x 10 rows).
Can someone give me some code with which i can check if there is a certain
value in that range.

Example :

I want to check if the GRID contains the value A.
IF it contains A THEN some actions have to follow.

If the GRID contains the value B
some other actions have to follow.

..........

..........


If the GRID contains the value Z
some other actions have to follow.

Thanx for your replies