Thread: 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

Try

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


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

"Tomasz Klim" <tklim-ms@komputronik.pl> wrote in message
news:%232NfPsijGHA.4504@TK2MSFTNGP03.phx.gbl...
> 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
>
>