By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,526 Members | 2,189 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,526 IT Pros & Developers. It's quick & easy.

What is the best way to format an Excel sheet?

neo008
P: 85
Hi all,

What is the best way to format cells of an Excel sheet?

I have read somewhere "object.range.property" method. but it's tedious if we do it cell by cell. Moreover most of the properties I know are not supporting with.


Where can I get complete property list along with syntax?

Can somebody help me please.


NE☼
Jun 28 '07 #1
Share this Question
Share on Google+
3 Replies


danp129
Expert 100+
P: 321
Have you tried recording a macro to do want you want and then looking at the code? You can use object browser to see what properties an object has.
Jun 28 '07 #2

Expert 5K+
P: 8,434
Where can I get complete property list along with syntax?
In the online help.
Jun 28 '07 #3

neo008
P: 85
That's a good Idea. danp129.

Thank you too Killer.



NE☼
Jun 29 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.