Fill the last row with Color

How to edit the code below so that it only fills till Column N instead of the entire row??

Please Login or Register  to view this content.

Thanks,

I want to fill the entire Lastrow from columns A to N
The above code just fill in the Nth column last row.

Thanks,

You need to look at my last post, #3. Looks like you were commenting based on post #2.

Throwing an syntax error, even though no syntax error was found