Need Alternative to Cells() Command to Reference Strings

Question

Oddly enough, I am surprised that I cannot find this information online! I am trying to use the following code:

If Cells(RowCount, 215).Value = "Edge Roughness" Then
    sb.Append "ER"
End If

The cell needs to be an exact match to the text string. For example, some cells are just "Width" while some are "Width Roughness"

Can somebody explain why I cannot use the Cells(RowCount, 215) command? Key note: it has to be variable so that I can use the RowCount command.

Dunno, why can't you? Cells(1,215) is the 215th column on the first row ... what happens when you use it? — Alex K.
– Alex K., Commented Aug 3, 2015 at 16:03
Application defined or object defined error. I can post the entire code if necessary. — Coding Novice
– Coding Novice, Commented Aug 3, 2015 at 16:04
Are you referring to a cell on another workbook? and what is the value of RowCount when you get this error? How does RowCount get it's value. Please supply the full code. — SierraOscar
– SierraOscar, Commented Aug 3, 2015 at 16:09

Coding Novice · Accepted Answer · 2015-08-03 16:37:44Z

2

You can use range. It is for the worksheet.

Range("A" & RowCount).Value

edited Aug 3, 2015 at 16:37

Coding Novice

4473 gold badges9 silver badges24 bronze badges

answered Aug 3, 2015 at 16:01

MatthewD

6,8215 gold badges24 silver badges44 bronze badges

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

3 Comments

Coding Novice Over a year ago

This does not allow me to use the variable RowCount

Coding Novice Over a year ago

Can I do Range("A"RowCount)?

KFichter Over a year ago

Sure it does, the declaration is just a little different. You'd need to convert the column number to a column letter then use Range(columnLetter & RowCount).Value. You can also do Range("A" & RowCount).Value

Collectives™ on Stack Overflow

Need Alternative to Cells() Command to Reference Strings

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related