Categories
Microsoft Office Productivity Technology

Uselfull Excel Macro – Make Contents Page

I commonly have large excel spreadsheets with many tabs or worksheets within the same workbook.

I use the following Microsoft excel macro to generate a contents page.

NOTE: I’m assuming the “Contents” worksheet will be the first and the list will be generated from A2 downwards.

Private Sub CommandButton1_Click()
    For i = 2 To Sheets.Count
        Range("a" & i) = Sheets(i).Name
        ActiveSheet.Hyperlinks.Add Anchor:=Range("a" & i), Address:="", SubAddress:="'" & Sheets(i).Name & "'!A1", TextToDisplay:=Sheets(i).Name
    Next i
    Columns("A:A").EntireColumn.AutoFit
End Sub
Categories
Reading Ross

What I’m Reading – The Martian

It’s been a while since I found a true “can’t put down” book.

I have found one The Martian by Andy Weir:

The story of an astronaut left on Mars.

Categories
Me Quantified Self Technology

Hacking Sleep – What Works For Me

The Problem

For a long while I have struggled with the amount a quality of sleep I get so I decided to address this. For years I was using a FitBit Ultra and this allowed me to track the quality and duration of my sleeping. I have made a number of changes to slowly address this problem.

I knew I had a problem when my really loud buzzy alarm clock and the TWO alarms set on my mobile phone failed to get me to wake in the morning.

Categories
Uncategorized

Every Office Needs a Giant Severed Robot Hand Conference Table

handWhen your software company is called Robotoki, it only makes sense that your offices would be adorned with random robo-memorabilia. But the company’s brand new conference table, which sits atop the severed hand from some giant imaginary mech, goes beyond the call of duty. Designed and built by Tom Spina Designs, the table looks like […]

from Gizmodo UK http://ift.tt/voEe7c
via IFTTT