Page Breaks Problem ( Emergency , Gurus.. PleaseHelp)

U

usiddiqui

Can any body help me immediately.

Please understand the snario.


I am setting the page breaks on my excel sheet. that i had generated b
executing code from Visual Basic. When i first time generate the exce
sheet the code used to set the page breaks executes right. but when
second time execute the code. the code to set the page breaks, Fails.

Below is given the code that i am using to set the page breaks.

Plese help ..


wrkSheet.HPageBreaks.Add Before:=Cells(Row, 1)
wrkSheet.VPageBreaks.Add Before:=Cells(1, CmbMaxColumns+1)


Follwing is the error that s show when i execute the code secon
time... Please Please help. I am just stuck... I have to send th
shipment of the software project tonight...

Error : '462'
The Remote server machine does not exist or is un available


This is to note that i am not using any network resource. its strang
for me..why i am getting this erro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please please please help... great trouble here..(Page Breaks Problem) 4
Adding multiple page breaks - at start of each day 4
VBA Coding Help for Beginner 0
Setting Page Breaks 1
Excel 2007 page break problem 0
VBA Export to PDF 0
Can't set visible page breaks permanently 0
Vertical page breaks won't drag in Page Break Preview 0

Top