View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wired Hosting News Wired Hosting News is offline
external usenet poster
 
Posts: 8
Default Cell Formatting Failure

Can anyone tell me why this fails

Sub SizeAndFormat(ws As Worksheet)

With ws.Columns("D:D")

.ColumnWidth = 12
.Font.Size = 8
.Style = "Currency" - This Line fails

'other code...

end sub

There is not an error code associated. The code just exits the function and
returns to its' calling point. If I comment out this line, everything else
works.

Any ideas?