I have a list of domain names in column A. And, in Column B, I would like to show the IP address of the site in the cell from column A.
I have a VBA function that gets the IP address:
GetIPFromHostName
So, if I want to retrieve the IP address for yahoo.com, I would type yahoo.com in A1, and in Cell B1, I would enter:
=GetIPFromHostName(A1)
This should (theoretically) display the IP for yahoo.com. Mind you, don't get hung up on multiple IPs here - that's not the problem.
The function does not work when it's in the Excel cell. It has worked in the past, infrequently and on different occasions. But, other times it does not work at all.
Complicating things further, this piece of a sub function in VBA pops a message box works and it works great, reads right from the Excel sheet:
MsgBox GetIPFromHostName( Range("A1").Value)
I'm so pwned by this. Help if you can!
BTB, I do not believe timeouts are the problem either -- since the alerts provide instant replies to the IP requests.
2007-08-16
06:50:04
·
4 answers
·
asked by
strayinma
4