VBA in Excel - use loop counter to reference cells

Question

I have cells that are either "True" or "False". I have names for these cells so that it's easier for me to reference in my codes. For Example, instead of saying cell "A1" I say cell "Apples". The cell names are:
Apples
Oranges
Onions
Potatoes
Bananas

In a separate worksheet I have under column A:
Apples
Oranges
Bananas
This range of cells is named "Fruit". So this list is meant to be a list of the cell names I want to check.

I want to use a for loop to check if each cell referenced under in the range "Fruit" is true. This is my code:

For Each item In [Fruit]
    If Worksheets("Inventory").Range(item).Value = True Then
        --Do stuff--
    End If
Next item

I keep getting an error when trying to reference the cell. How can I do this? Is it possible for me to use the counter to reference the cell?

Tim Williams · Accepted Answer · 2013-11-05 00:09:42Z

1

close...

For Each item In [Fruit]
    If Worksheets("Inventory").Range(item.Value) = True Then
        '--Do stuff--
    End If
Next item

answered Nov 5, 2013 at 0:09

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA in Excel - use loop counter to reference cells

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related