You're welcome.........thanks for the feedback

Vaya con Dios,
Chuck, CABGx3




"dhoward via OfficeKB.com" wrote:

Thank you! It worked.

CLR wrote:
The problem is in the word wrapping .........

The line should read, all on one line.......

Selection.AutoFill Destination:=Range ("I8:I"
&Cells(Rows.Count,8).End(xlUp).Row)

or, this would be acceptable........

Selection.AutoFill Destination:=Range ("I8:I" & _
Cells(Rows.Count,8).End(xlUp).Row)

Notice the space and underscore at the end of the first line......that
connects the two lines together in VBA........

Vaya con Dios,
Chuck, CABGx3

Thanks for the response. I believe I had a Range Selection line. (I'm not
too experienced with complex macros.) Here's the macro as I typed it:
[quoted text clipped - 22 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