Can anybody help me???
I have an excel file which was originially written in Office 97 bu
then updated under 2000. Since the updates have occured, several of th
object function give an run-time error 1004 when run again under 97

for example:
Sheet2.Range("A37:L50").Borders.LineStyle = xlLineStyleNone

this is just one example but occurs with application.object functions.
:

--
Craig Phillip
-----------------------------------------------------------------------
Craig Phillips's Profile: http://www.excelforum.com/member.php...fo&userid=1554
View this thread: http://www.excelforum.com/showthread.php?threadid=31474

Generally:

Multiversion development should be done in the LOWEST version.
then tested for anomalies in higher version(s).

I've tested your code line in xl97 dutch version
and it works perfectly.

with 1 adjustment :)

Worksheets(2).Range("A37:L50").Borders.LineStyle = xlLineStyleNone

Note that Sheet2 is the codename of a worksheet object
(= the name of the VBcomponent in the workbook's VBproject)
which in a newly created sheet in Dutch would be "Blad2"


so the question is... does the ACTIVEworkbook contain
a worksheet with the CODEname sheet2?




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

Craig Phillips wrote in message
:


Can anybody help me???
I have an excel file which was originially written in Office 97 but
then updated under 2000. Since the updates have occured, several of
the
object function give an run-time error 1004 when run again under 97

for example:
Sheet2.Range("A37:L50").Borders.LineStyle = xlLineStyleNone

this is just one example but occurs with application.object functions.
:(