Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decoding a Range String
sStr = "B11:Z56"
set rng = Range(sStr) rng.column ' begin column rng.Row ' begin row rng.columns(rng.columns.count).Column ' end column rng.Rows.(rng.rows.count).Row ' end row -- Regards, Tom Ogilvy "John Kauffman" wrote in message ... Hello. I am writing a userform to collect a range from the user, manipulating the selected array of data, and then generating the results in other worksheets. I need to use the selected string to decide which columns to manipulate in the other worksheets, so I need to decode the "selected range" string into BeginRow, EndRow, BeginColumn and EndColumn. I can imagine an algorithm to do this based on ASC and CHR conversions using the MID function, but I wonder it there is an easier way such as an existing VBA function that will take care of this for me. Thanks, John Kauffman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decoding a Range String
Just what I was hoping for. It works.
Thanks John Kauffma ----- Tom Ogilvy wrote: ---- sStr = "B11:Z56 set rng = Range(sStr rng.column ' begin colum rng.Row ' begin ro rng.columns(rng.columns.count).Column ' end colum rng.Rows.(rng.rows.count).Row ' end ro -- Regards Tom Ogilv "John Kauffman" wrote in messag .. Hello I am writing a userform to collect a range from the user, manipulating th selected array of data, and then generating the results in other worksheets I need to use the selected string to decide which columns to manipulate i the other worksheets, so I need to decode the "selected range" string int BeginRow, EndRow, BeginColumn and EndColumn. I can imagine an algorithm t do this based on ASC and CHR conversions using the MID function, but wonder it there is an easier way such as an existing VBA function that wil take care of this for me Thanks John Kauffma |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decoding an old macro | Excel Discussion (Misc queries) | |||
how can I open a file if its needs decoding with BINHEX4 | Excel Discussion (Misc queries) | |||
String to Range? | Excel Programming | |||
A question about decoding, substitute or vlookup of character. | Excel Programming | |||
Decoding Part number entries for all values embedded | Excel Programming |