IF statement to test the contents of a cell

**Dowsey1977** · 01-21-2010, 09:26 AM

Hi,

I'm reasonably new to VBA and need some what I am hoping is simple help.

I want to write and IF statement to test the contents of a cell in row 2 of a selected column. So for example, if I have L15 selected, I want the IF statement to test L2.

I can do the IF statement fine, I just don't know how to ask it to reference row 2 of the current column selected (which may vary).

Any ideas??

**romperstomper** · 01-21-2010, 09:28 AM

You can use:

Please Login or Register  to view this content.

**Dowsey1977** · 01-21-2010, 09:30 AM

Excellent, many thanks for the prompt reply.

**Dowsey1977** · 01-21-2010, 12:22 PM

Hi,

I am going to make this slightly more complex now I think. I want to run this IF statement against a range of cells, but for each cell in the range (covering multiple columns) I want it to refer to row 2 of that column. This is what I have so far, but it ain't working...

Please Login or Register  to view this content.

**romperstomper** · 01-21-2010, 12:24 PM

First question:
Why are you using the Worksheet_Change event to loop through an entire range? (there may be a good reason, but I like to check!)
Second, I think your problem is the reference to Activecell in the middle of the code:

Please Login or Register  to view this content.

**Dowsey1977** · 01-21-2010, 12:31 PM

Thanks, the change certainly fixed the problem...

In answer to your first question...I don't know. Is there a better way of doing this? I am using VB to perform this task because of the number of conditions I want to check (on top of the one above). I was given code to allow me to do this, which is what has been modified (from the first IF) to fit my needs.

**romperstomper** · 01-21-2010, 12:44 PM

The Change event fires when you change a value on a worksheet. Typically, your code would respond by only checking the relevant cells (e.g. the changed cells, or cells on the same row for example) rather than looping through every cell in that range every time any cell on the sheet is changed.