Need to reference a cell and a value together

[harts]

I am trying to reference a range of cells starts with B5 and I want it to go to B??. AA1 has a countif formula that returns a number in it. Need to write it this was instead of using xlup because there is info in that row that I do not want included. Thanks for any help


For Each c In Worksheets("plugs").Range("B5", Range("B" & Range("aa1").Value))

 

[steve the fish]

Here's a way:

For Each c In Worksheets("plugs").Range("B5:B" & Worksheets("plugs").Range("aa1").Value)
    MsgBox c.Address
Next

 

[harts]

That worked perfect thank you for your reply