Efficiently transform variables into range address

F

Frank Kabel

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
Click to expand...
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
Click to expand...
advance for your example function.
 
Top