Using Cells in VBA

[HWL]

I have no trouble uses .cells(row, col) in VBA if both row and col are represented by numbers, but what if I wanted to convert a letter to a number to use with cells. For example, say I wanted "B" to convert to 2 so I could use it in .cells?

Is this making sense?

 

[Jonmo1]

You can use a letter in Cells

Cells(1,"A") - same as Cells(1,1)

 

[HWL]

You can use a letter in Cells

Cells(1,"A") - same as Cells(1,1)

Hmm, guess I never tried, let's see....works fine. WOW! and duh to me.
Thanks

 

[Jonmo1]

Glad to help..

That's the main advantage cells has over range..
It can use either number or letter for the column

Also, the key is the quotes "A" instead of just A
Without the quotes, it would think A is a variable...

 

[HWL]

Glad to help..

That's the main advantage cells has over range..
It can use either number or letter for the column

Also, the key is the quotes "A" instead of just A
Without the quotes, it would think A is a variable...

Seems to work with just a letter without quotes as well I noticed.