Please look into Resize property in the VBA help.
Your code can be written like this.

Range("A1").Offset(4, 1).Resize(1, 9).Copy


Regards,
Colo
http://www.puremis.net/excel/

"Ramon Nunez via OfficeKB.com" wrote in message
...
I create a form in office 2000 which run fine, but when user open it on
office 97, I got the message:
run-time error 5941
the requested member of the collection does not exist.

On the form I populate some formfields with data inserted by user.
Any ideas why the forms works fine on office 2000 or XP but not on 97.

The way I assign values to formfiels is like this:
Dim strCltAddress As String
strCltAddress = frmUserInfo.txtAddress.Text
ActiveDocument.FormFields("ClaimantAddress").Resul t = strCltAddress

which creates the error.

--
Message posted via http://www.officekb.com