copying and pasting cell values

Hi everyone!

I've got the following code which is meant to find cells with no values, colour the cells in, and then replace the missing value with the average of that column. the average is located in a different sheet

Please Login or Register  to view this content.

It throws error 400. However, I have the same code (MissingValues), which colours it all in red, as shown on the file submitted.

The code will later be used to more or less the same extent, except for, it will search for outliers (based on outlier limit) and colouring in the outliers in yellow (hence the name of the sub)

Much appreciate any help!

Kurifodo

Please check the Forum Rules at http://www.excelforum.com/forum-rule...rum-rules.html and add Code Tags around your code example. Otherwise you will get few, if any, replies.

While you're at it, please add a sample workbook si that your problem can be viewed in context.

Regards