Michelle,

It is probably due to not qualifying every object property that you
reference with a full application qualifier. In this case, I am referring to
rsData!Rate_Input_Time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Michelle" wrote in message
...
Hi all

I am automating excel 97 from Access 97

I am having problems with the range resize property. the relevant
porition of my code is as follows

rngWork.select
xlapp.selection.resize(0,Int(rsData!Rate_Input_Tim e)).Select

I get a runtime error 1004 - application-defined or object-defined error

Can anyone help please

I have tried to use the resize property in a number of solutions i have
built but have never managed to get it to work through automation. I
therefore have built work arounds which lead to much more code. I thought I
would give you guys a try this time and try and get the answer once and for
all.

thanks for your help
Michelle