I’m always looking for this, so I figure here is as good as any for safe keeping.. It’s simple to use…

1. Press Alt-F11 in Excel to get to the VBA screen.
2. Right click on the Project View
3. Click Add Module
4. Add the following snippet.
5. Use: GetHostname("4.2.2.1") in any Excel cell.

Continue reading →