Posted to microsoft.public.excel.programming
|
|
range to string
Dim rngstr as string
rngStr=destrange.address()
"usadream" wrote:
Hi all,
i need to pass a string (e.g. "D10:D150") that defines a range as
argument to a function.
My problem: I have this range defined as range object:
Code:
--------------------
Set destrange = activeSheet.Range(Cells(myDestinationStartRow, myDestinationCol), Cells(myDestinationEndRow, myDestinationCol))
--------------------
How can i convert this range to a string defined above? is this
possible?
regards, thomas
--
usadream
------------------------------------------------------------------------
usadream's Profile: http://www.excelforum.com/member.php...o&userid=32703
View this thread: http://www.excelforum.com/showthread...hreadid=530028
|