2 Questions on Excel.....

[anilgoje]

Hi,
Can anyone tell me solutions for these 2 questions...

1. How to fix the width of a particular cell

2. How to fix the page break to a particular column.Suppose that i want to see only 9 columns in the print preview ie column I in the sheet.

Any help will be appreciated....

Thanks

[anilgoje]

I have fixed one problem by my own and it works.I will be very much thankful if anyone knows the solution for my second problem.

[mattbrown]

You could set the print area

I believe there is a method called setprintarea that you can pass a range to.

go to msdn.microsoft.com
and use the Library to find some more information

[anilgoje]

Hi mattbrown,
Thanks alot!!!!!!!!!
It works.....As you told there is a prperty called printarea in the worksheet.pagesetup.I tried it and its working...

Thank you once again...