Range and numbers

[AlexanderBB]

I found this here
Anything that you can do with a column letter, you can do with a column #.
It's often easier to work with that number anyway.
There is very rarely a need to actually convert a number to column letter.
Other than for visual representation, so you can say to a user/student/boss or something "See, it's in column X"
But Excel doesn't 'need' it.
and applied this logic. But now I'm a bit stuck I have (example) .range("J2")
How is range expressed with numbers only ? Or should I use .cells(2,9) ?

 

[My Aswer Is This]

Yes use: cells(2,9)

 

[AlexanderBB]

Goodoo, thanks.

 

[Peter_SSs]

I have (example) .range("J2")
How is range expressed with numbers only ? Or should I use .cells(2,9) ?

.. except of course it would be .cells(2,10) for J2 if it was qualified to a worksheet.

 

[DanteAmor]

It's often easier to work with that number anyway.

It depends on each programmer, you get used to using letters or numbers. In my case I prefer to use letters.

There is very rarely a need to actually convert a number to column letter.

It is often necessary to convert column numbers to column letters when you use letters in formulas, examples:
VBA code to multiply many rows with some conditions
count without duplicate
Now I can't find examples of converting number to letter, but the idea is that it is easier to work with letters when it comes to putting the formulas in vba.

Other than for visual representation, so you can say to a user/student/boss or something "See, it's in column X"
But Excel doesn't 'need' it.

An advantage of using Range instead of Cell, with Range you can access the VBA intellisense that will show you the properties or methods of the object:

and applied this logic. But now I'm a bit stuck I have (example) .range("J2")
How is range expressed with numbers only ? Or should I use .cells(2,9) ?

Then, .Range("J2") is equivalent to .Cells(2, 10)
You can even use .Cells(2, "J")

Or a combination of both, you could have numbers and access to vba intellisense:

.Range(.Cells(2, 10).Address)

 

[RoryA]

If you use FormulaR1C1 (or local equivalent) then column numbers can be used without having to convert to letters.