| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Efficiently transform variables into range address
Hi
try Range("A1").resize(lngRows,lngCols).select -----Original Message----- Hello: VBA in Excel XP with Win 2000. I have two variables that are both long data types. I need to somehow convert these into an equivalent range address that they would consume if starting at cell "A1". For example suppose: lngCols = 4 lngRows = 3 Range address would be: A1:D3 How in the world can I do this efficiently? Thanks in advance for your example function. . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
| How do I transform numbers (different ranges) to text (diff. range | Excel Worksheet Functions | |||
| How to efficiently declare variables | Excel Discussion (Misc queries) | |||
| How to get 500 hyperlink address efficiently? | Excel Discussion (Misc queries) | |||
| Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
Threaded Mode
