khalid79m
04-07-2009, 03:04 AM
With Range("Talk_Time").SpecialCells(xlCellTypeBlanks)
.NumberFormat = "hh:mm:ss"
End With
My code looks changes the format of all blanks cells in range ("Talk_Time") to HH:MM:SS.
but if there are no blank cells it throws up a debug message cells not found.. ? can anyone help:(
.NumberFormat = "hh:mm:ss"
End With
My code looks changes the format of all blanks cells in range ("Talk_Time") to HH:MM:SS.
but if there are no blank cells it throws up a debug message cells not found.. ? can anyone help:(