Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Addressing | New Users to Excel | |||
Cell addressing | Excel Worksheet Functions | |||
Cell addressing | Excel Worksheet Functions | |||
Cell addressing | Excel Worksheet Functions | |||
VBA Cell Addressing | Excel Discussion (Misc queries) |