Macro to enter variables to Shell Command

This was very helpful. It got me closer to my goal.

I have several hundred sections with a host name, a macro button, and an IP Address below.

I have already built out the individual macros but became interested in building only one macro for future use. Really, the only variable is the IP Address and the Macro name. Setting up one macro will remove the macro name.

Here's what I've tried so far:

1st

Please Login or Register  to view this content.

Doesn't work so far...

Then:

Please Login or Register  to view this content.

This brings up cannot find pingTrue as a command to run (I chuckled...)

Then:

Please Login or Register  to view this content.

This brings up cannot find host True to ping.

Given that I have several hundred boxes with 3 or 4 different commands (RDP, ping, Putty, etc...) whose only variable is the IP Address 2 cell below the button, is there a way to create a single macro that will ping that IP Address?

The ranges change per sheet.

P.S. This is only my 2nd attempt at building out macros...