What is rsData!Rage_Input_Time

Is it something from access that resolves to an interger?

Anyway, you can't resize to zero. You have to have at least 1 row and 1
column.

if you want to not resize on row, then leave it blank

xlapp.selection.resize( ,Int(rsData!Rate_Input_Time)).Select

--
Regards,
Tom Ogilvy


"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