String to range conversion

[ElvinK]

Hi all,

Currently, I'm having some difficulties in setting a range using two string values. Is there any idea how can I combine both the string values into a range.

For example, string variable Col consists of "B" while string variable k has a value of "3".
I would like excel to call for the range "B3".

Instead of .range("B3")
is it possible to to call for .range(Col & k1)
Appreciate any assistance.

[jindon]

That would be

Please Login or Register  to view this content.

[ElvinK]

Hi jindon, thank you for the prompt reply.

However, I would like to print something in range(col & k) through a If-Else command

I've called the cell through an example as follows

Please Login or Register  to view this content.

However, I keep getting an error with that particular line.
Any idea whats going on ?

Thank you once again.

[jindon]

What kind of error are you getting?

[ElvinK]

Object defined or application defined error.

[jindon]

Then most probably value of col and/or k are not properly assigned.

[ElvinK]

Then most probably value of col and/or k are not properly assigned.

Please Login or Register  to view this content.

The above is the code. Would you be able to help me do some troubleshooting?

[ElvinK]

Hi jindon,
I think I've managed to solve it.
It was a variable mismatch error.

Thank you for assistance once again.

[jindon]

OK, that's good.