I hereby claim:
- I am supergrass71 on github.
- I am mjn (https://keybase.io/mjn) on keybase.
- I have a public key ASBgpJ6qJIkK8yqkhT17HjieFEyIRBdF2gNc2936LVcd3Qo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
Sub createNewStepsWorksheet() | |
Dim totalSheets As Integer | |
Dim sheetName As String | |
sheetName = ActiveCell.Value | |
With ActiveWorkbook | |
totalSheets = .Worksheets.Count | |
.Sheets(2).Copy After:=Sheets(totalSheets) |
Sub RemoveHlinks() | |
'https://www.extendoffice.com/documents/excel/2221-excel-remove-hyperlink-without-removing-formatting.html | |
'Update 20180220 special sauce from Murray Neish | |
Dim Rng As Range | |
Dim WorkRng As Range | |
Dim TempRng As Range | |
Dim UsedRng As Range | |
Dim xLink As Hyperlink | |
Dim xTitleId As String |