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.
.