I just tried it again, just as I posted, with the Range selection line
before the AutoFill line.......worked fine on my XL97. It does fail with no
Range Selection line in place.......Do you have a Range Selection line in
place?........perhaps if you posted your whole macro we could see the
problem.

Vaya con Dios,
Chuck, CABGx3


"dhoward via OfficeKB.com" <u10035@uwe wrote in message
news:62d9a37f16e25@uwe...
Thanks, I just tried to enter this as a macro but I'm getting a syntex
error
message on this part. I've entered it just as you have it below.
Selection.AutoFill Destination:=Range("i8:i" & _
cells(rows.count,8).End(xlup).Row)

CLR wrote:
Tom Ogilvy gave me this code one time when I had what I think was a
similar
problem..........perhaps it's what you're looking for.......

Range("i8").Formula = "=H8 + G8"
Range("i8").Select
Selection.AutoFill Destination:=Range("i8:i" & _
cells(rows.count,8).End(xlup).Row) '8 stands for column H

hth
Vaya con Dios,
Chuck, CABGx3

Thanks for the suggestion. This works great when it is just a one time
use.
However, I do this a lot in macros and find that using auto fill
doesn't work
[quoted text clipped - 13 lines]
didn't prevent it. What can I try to paste only in the active area
of my
sheet?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1