Autofill Destination Range

I am running in to a problem that maybe someone can solve.

I am trying to use a range based on the last cell of column P to fill in the data from O15:016 down to the what line Column P's Last row is.

J15 and J16 have the custom formating so I can get it to copy the format over to O15 and O16, but when I try to get auto fill to select the two and copy to the bottom of the list I get Method 'Range' of object '_Global' failed

Please Login or Register  to view this content.

any help would be appreciated

I took the extra range out

Please Login or Register  to view this content.

and it gave me Autofill method of Range class failed.

What is it when you get the error?

Error is:
Run-Time error '1004':
AutoFill method of Range class failed

Also, what are you actually autofilling?

Location Name (the name of the center that sent the data) with the formating of first line with no cell shading, the second with.

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.

Norie you ROCK. Not including the source was the reason. I changed the code to read:

Please Login or Register  to view this content.

and it works like a charm now.

Thank you so much. I add reputation to your post. Thank you again.