LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I'm unable to change font size on a excell sheet Steve Excel Worksheet Functions 1 January 3rd 10 06:03 PM
Can one change the font or format of a sheet name? KMcGrail Excel Discussion (Misc queries) 2 June 14th 05 10:43 AM
Unable to Set Underline Property of Font Class Sherwood Excel Programming 3 January 13th 05 08:25 PM
Unable to set Bold property of the Font Class Mike Lee Excel Programming 2 January 19th 04 06:23 PM
unable to set the colorindex property of the font class steve Excel Programming 3 December 17th 03 02:41 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"