Extracting first (cell)adress in VBA from string

[Willem!]

Hi!

I want to extract the first (cell)adress from a string (which is the string of a range) in VBA.

Example:

strRange = "$P$2:$T$4"

strCell = *some function/code* = "$P$2"

Can this be done in a simple way?

TIA

 

[Colin Legg]

Hi,

How would the "$P$2:$T$4" string be assigned to your strRange variable in the actual code? Using the range object's address property? What do you want to do with the first cell's address once you have it?

 

[RoryA]

strCell = Split(strRange, ":")(0)

would work.

 

[Willem!]

Thanx Rory! That worked like a charm

 

[Willem!]

Hi,

How would the "$P$2:$T$4" string be assigned to your strRange variable in the actual code? Using the range object's address property? What do you want to do with the first cell's address once you have it?

Hi Colin, yes, I by using the object's address property I assign a value to strRange

On my sheet a user can select with a RefEdit-control a certain range from which I need the upperleft-, and the lowerright-corner. I need these for a VBA-function which creates a giant matrix (since my matrix has more than 73 variables I cannot use array-functions, so I need UDF's).

Thanx for your help!