[RESOLVED] Programmatically Centered Text In Excel Spreadsheet

[Hack]

[color=navy]Then you probably have an error somewhere that is causing the intellisense not to function.

Any ideas where that error could be? The Sub and all of its wonders works just fine. I just wanted a little formatting done

Also, you shouldnt use the New in the dimensioning in theis line

Dim objExcel As [b]New[/b] Excel.Application
 
'Should do like...
Dim objExcel As Excel.Application
 
Set objExcel = New Excel.Application

Yes, I know and I have a nasty habit of doing that. It is funny. I can catch things like this when I'm looking at other peoples code, you would think I would be able to catch it when looking at mine.