I have people entering URLs in a cell. I then need to say something like

Code:
webaddress=activecell.value
msgbox webaddress
where webaddress is a variable. WHen I do this the webaddress variable is holding a blank value. Is there some formatting issue where excel won't see a url as text? I've checked and I know that there is a value in the currently active cell.