Quick UDF to do the trick:
http://www.EXCELGAARD.dk/Lib/UDFs/IP/


Sam Wilson wrote:
Hi,

How can I get my the IP address of a computer using VBA? I was hoping
it'd be through environ() but it seems not...

Sam