autofill range class failure
when you paste special, you have to do the copy separately - just the way it
is.
--
Regards,
Tom Ogilvy
"Susan" wrote:
tom & jim:
i originally had it as including the starting cell, but when it
wouldn't work i figured that the starting cell couldn't be in the
range. that's why i changed it. but i think having the startcell be a
2-cell range made it work.
thank you!
now, while i have you, tom was trying to teach me to combine
commands.......
can you tell me why this works:
InsRange1.Copy
InsRange2.PasteSpecial Paste:=xlPasteAll
but this doesn't???
InsRange1.Copy("InsRange2").PasteSpecial Paste:=xlPasteAll
what am i doing wrong here? it gives me an error "unable to get the
copy property of the range class."
thanks
susan (gratefully feeling much better now!)
|