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