Friday, February 06, 2009
Excel manipulation with VBscript
So I've played around with it more since the last time I mentioned it, here's a couple new tricks.
Autofit your spreadhseet columns:
cartSheet.Columns.AutoFit
Autofilter your columns:
cartSheet.Cells.autofilter 3, "DOWN"
Bold a range of cells:
objExcel.ActiveWorkbook.Worksheets(1).Range("A1:J1").Font.Bold = True
At some point I'll add to the tutorial...
Labels: programming
PermaLink / Posted by: Tony


