Using VBA, add line break to header or footer with Chr(13).
E.g.
ActiveSheet.PageSetup.LeftFooter = "Foo bar" & Chr(13) & "Another line"
Pages
Other stuff
Category Archives: Software
Add to ThisWorkbook->Workbook code.
Private Sub Workbook_Open()
Dim oSht As Worksheet
Dim xlCalc As XlCalculation
On Error GoTo ErrorHandler
'remember the user's calculation setting before setting it to manual
xlCalc = Application.Calculation
Application.Calculation = xlCalculationManual
For Each oSht In Worksheets
oSht.EnableCalculation = False
oSht.EnableCalculation = True
Next oSht
Application.Calculate
ErrorExit:
On Error Resume Next
'restore the user's calculation setting
[...]
Had to remove attachments from a bunch of emails. This VBA code did the trick (although it does not know how to handle attached emails, i.e. emails that have another email attached).
(Remembe to create a reference to the Microsoft Scripting Runtime library: in VBA choose Tools -> References and check its checkbox.)
Option Explicit
Dim blnSaveAttach As [...]
[Excel] Days in Month
01-Dec-09=DAY(DATE(YEAR(A1);MONTH(A1)+1;1)-1)
, where A1 contains a valid date.
How to access 1Password passwords on Windows?
(I had no idea it was this easy.)
This tip uses Dropbox, a multi-platform file syncing app. The only problem is that the access is read-only. But it's better than nothing.
In 1Password (on your mac), select the Agile Keychain to be saved in your dropbox folder (I created a new [...]