Office 97 Code Edited in 2000 Will Not Run

C

Craig Phillips

Can anybody help as I'm at the END!
I have a spreadsheet which was created and is run in Office97 I edite
it in Office2000 and since then, the most basic of operations will fai
with a "runtime 1004" error.

To remedy the situation, I attempted to redo the completed work unde
Office97 which was ok for a while until it was opened and retouche
under Office2000.
I will include an example of where it goes wrong.

Sheet2.Cells(37, 1).Borders.LineStyle = xlLineStyleNone

this is simple enough and will work fine under 2000 but fails in 97 an
ideas........? :(

p.s. The problem only appeard to occur when attempting to use;
application.
worksheet.
et
 
Top