I received a spreadsheet with a list of addresses setup so you can click the name in the cell and it would open. I wanted to export the actual url which is inside the cell.
You can do this with a function. Open the VBA editor with Fn/Option F11 on the Mac. Then Open Modules and insert a new module with a name of your choosing.
Paste in the following function, save and exit the VBA editor
Function GetCellURL(cell As Range) As String
On Error Resume Next
GetCellURL = cell.Hyperlinks(1).Address
End Function
I started a project with many different ec2 instance types and found the following link very useful recently.
https://alestic.com/2014/01/ec2-ssh-username/
Continue reading →I moved to Python3 and looked back and realized I had a ton of things installed globally for Python2. With this realization I wanted to clean everything out.
Here is one method
$ pip freeze > requirements.txt
$ pip uninstall -y -r requirements.txt
A quick command to figure out what your IP address is.
$ curl checkip.amazonaws.com