Cell addressing
 

Hello

I have two cells, for example (2,3) and (16,7), and I want to create Range
from them - C2:G16.

How to convert (2,3) into C2 ? Of course I know, that I can do it myself
building an array of letters, but is there a way to force Excel into this
conversion?

Thank you in advance!

tk

Cell addressing
 

Try

Range(Cells(2, 3), Cells(16, 7)).Address


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Tomasz Klim" wrote in message
...
Hello

I have two cells, for example (2,3) and (16,7), and I want to
create Range from them - C2:G16.

How to convert (2,3) into C2 ? Of course I know, that I can do
it myself building an array of letters, but is there a way to
force Excel into this conversion?

Thank you in advance!

tk