Saturday, August 11, 2012

20 Things I want in my Tablet

Dear Tablet PC Manufacturers,

Google has started shipping its latest tablet PC called Google Nexus 7. Apple’s iPad is already a market leader, but they are also planning to launch iPad Mini in September. Amazon’s Kindle Fire caused a lot of positive vibe last year while Lenovo and Samsung has some offerings as well. But the most noise, nowadays, is coming from Microsoft, who is about to launch its surface tablet PC. So has been become quite difficult not to own a tablet PC nowadays. I am willing to pay a maximum of $300 but I have 20 things which I require in my tablet PC, which would enable me to replace my laptop (at least for home use) and give me even more. So if you want to earn my $300, then read this blog and make a tablet PC which fits the bill. 

Wednesday, January 18, 2012

How to list all sheets in Excel

Insert a new sheet and have that sheet active when you run the macro.

Right click on the sheet and click on 'view code'
Paste the below code and click on 'run'

"Private Sub ListSheets()
'list of sheet names starting at A1
Dim rng As Range
Dim i As Integer
Set rng = Range("A1")
For Each Sheet In ActiveWorkbook.Sheets
rng.Offset(i, 0).Value = Sheet.Name
i = i + 1
Next Sheet
End Sub"

'via Blog this'