Hi al

I am automating excel 97 from Access 9

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

rngWork.selec
xlapp.selection.resize(0,Int(rsData!Rate_Input_Tim e)).Selec

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

Can anyone help pleas

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 hel
Michelle