you too mate.
Hey Tim one other quick ?
How do you hide a specfic columns in a worksheet
lol, this is turning into a bit of an ultra thread. If this was Technet, I’d have 150000000 points and a handwritten gold embossed card from Satya and Bill 
Using the variables from before, you’d do something like below. It selects a cell that is on the same column to hide, then sets the Hidden attribute for the column concerned.
$ExcelWorkSheet.cells(5,5).select() $excel.Application.Selection.EntireColumn.Hidden = $true
lol,You deserve 150000000 points!
Thanks so Much
Happy New Year