Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range to string
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the POSITION IN A RANGE of text in a string that matches value(s) in a range | Excel Programming | |||
Retrieving range string from named range | Excel Programming | |||
Translate range name passed as string to a custom function to range addresses! | Excel Programming | |||
Passing a String in Array to Range as String | Excel Programming | |||
String to Range? | Excel Programming |