check if formula parameter is a cell-adress
 

Hi,

i have a dialog in which the user creates a formula with a cell range as
parameter (e.g. A1)
How can i check if the input of th euser is a valid cell range and not text
or anything else?

Thanks

Jens

check if formula parameter is a cell-adress
 

Try creating a range

On Error Resume Next
Set myRange = Range(user_input)
On Error Goto 0
If Not myRange Is Nothing Then
'ok
End If

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"kikde" wrote in message
...
Hi,

i have a dialog in which the user creates a formula with a cell range as
parameter (e.g. A1)
How can i check if the input of th euser is a valid cell range and not
text
or anything else?

Thanks

Jens