Help me plz

[chow76in]

hi friends
Worksheets("Sheet1").Range("A1:B3").Formula
"=HYPERLINK(http://messenger.yahoo.com,hi)"
like when try to asign url to cells using micros programaticaly i
gives error like "Application-defind or object-defind error" plz hel
me
Thank

 

[Ben]

Try Worksheets("Sheet1").Range("A1:B3").Formula =
"=HYPERLINK(""http://messenger.yahoo.com,hi"")"

 

[chow76in]

Thank u for ur help but it not working
it takes complete http://messenger.yahoo.com,hi as string but i wan
display only http://messenger.yahoo.com url and hi as a anchar string
plz help me thank

 

[JE McGimpsey]

One way:

Worksheets("Sheet1").Range("A1:B3").Formula = _
"=HYPERLINK(""http://messenger.yahoo.com"",""hi"")"

 

[chow76in]

Thanks a lo