Re: $$Excel-Macros$$ Excel Macro help : How to remove Page Break

2010-05-05 Thread Sundarvelan N
Hi friends, Please help. How to automatically set the range to clear the pagebreaks in different data. Thanks, Sundarvelan On Wed, May 5, 2010 at 5:42 AM, siti Vi wrote: > try: > > Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone > > > -- > On May 4, 6:09 pm, Sunda

Re: $$Excel-Macros$$ Excel Macro help : How to remove Page Break

2010-05-04 Thread siti Vi
try: Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone -- On May 4, 6:09 pm, Sundarvelan N wrote: > Hi Friends, > Please help me to solve the final step of my project. > I need to remove the page break lines to the end of the column upto which > the data is available. > Thanks