Norie you ROCK. Not including the source was the reason. I changed the code to read:The reason I'm asking that is because under certain conditions AutoFill can fail, for example if the destination range does not include the source range.
and it works like a charm now.![]()
Selection.AutoFill Destination:=Range("O15:" & pLR)
Thank you so much. I add reputation to your post. Thank you again.
Bookmarks