View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff[_11_] Geoff[_11_] is offline
external usenet poster
 
Posts: 4
Default Unable to format font after creating sheet

I have built that creates a worksheet and everything works perfect except
when I try to select the cells and change the font to Microsoft San Serif-8.
I get the error message "The Remote Server Machine does not exist or is
unavailable" My code is as follows:
xlSheet.Range("A1").Select
xlSheet.Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
With Selection.Font
.NAME = "Microsoft Sans Serif"
.Size = 8
End With
xlApp.Application.Visible = True

Any suggestions are greatly appreciated!