Posted in Geek on June 1st, 2011 by Surfrock66
I use excel constantly, and some things I require are freezing panes, autofitting the columns, adding auto filters, and standardizing the row heights. Here's the code for the macro I use, and I shortcut it with Ctrl+J.
Sub MakeSpreadsheetReadable()
'
' MakeSpreadsheetReadable Macro
' Macro recorded 5/23/2011 by Gullo, Joseph T. *HS
'
' Keyboard Shortcut: Ctrl+j
'
Rows("1:1").Select
Selection.AutoFilter
Range("A2").Select
ActiveWindow.FreezePanes = True
ActiveWindow.Zoom = 70
Cells.Select
Cells.EntireColumn.AutoFit
Selection.RowHeight = 12.75
End Sub
Tags: Excel, Macro
Leave A Comment »
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Posted in Homes on May 31st, 2011 by Surfrock66
Tags: 13 Georgetown Green
Leave A Comment »
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Posted in Random on May 9th, 2011 by Surfrock66
You know what sucks? When my spammy tweet-regurgitation posts take up my website and I do nothing forever. So I just excluded those posts from the front page, and just regular posts will show up here. You can still see the tweets by clicking the "tweets" category on the left, but for now, JUST PURE CONTENT.
Tags: Anti-Spam, Updates
Leave A Comment »
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Posted in Geek on December 13th, 2010 by Surfrock66
The wife and I are playing some minecraft, look how adorable we are:
Mrs. Pinkin (I can only embed one of us at a time to view :( )
Surfrock66
Tags: Minecraft
Leave A Comment »
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Posted in Homes on August 29th, 2010 by Surfrock66
Leave A Comment »
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
