Column Variable not Working

[jmcvay]

Hi, I'm using variable for row and column in 2 different lines of code. But only the row varaible works; the column variable doesn't and I can't figure out why.

partNum = Range("$B" & comRow).Text
comCat = Range(comCol & "$5").Text

Both variable are dimmed as integers. I thought there might be R1C1 issue, but I've tried referring that way too and it still won't work.

Any thoughts?

Thanks, jmac

 

[iggydarsa]

Range uses the letter of the column, not the number.

you can try:
comCat = Cells(5, comCol).value

Also I'd use .Value instead of .Text. Not sure if that would have an affect as well.

 

[jmcvay]

Jeez, something as simple as getting my row and column backwards; can't see the forest for the trees sometimes. Thanks; appreciate the help. Working like a charm now.

 

[Joe4]

Jeez, something as simple as getting my row and column backwards; can't see the forest for the trees sometimes. Thanks; appreciate the help. Working like a charm now.

No, it wasn't that at all.

With Range(...), it is always column first, and row second (and column reference ALWAYS must be alpha).
With Cells(...), it is always row first and column second, separated by a comma (and the column reference can be alpha or numeric).

So it depends on which one you use. Cells is more flexible, in that it allows you to use column numbers instead of column letters.