Button to insert new row to remove fill of certain cell?

[dragosnb]

Hello,
I have a button that inserts a new row in a big database, clears contents from previous row and in the same time keeps formulas where needed.
I need to make it to clear the colour of the cell in column F in the new row - to became from yellow or green to No fill.
Do you have any suggestions?
here is the code that i have so far:

Please Login or Register  to view this content.

[Fotis1991]

Perhaps something like this?

Please Login or Register  to view this content.

[dragosnb]

thanks for helping but unfortunately this doesn't work. When i click on the button i get "Compile error: Expected end with"

[Fotis1991]

Like this?

Please Login or Register  to view this content.

[dragosnb]

like this there isn't any error but it is removing the Fill of the first row and not only in column F but in other columns too.
I need the button to remove the fill only from the last inserted row and only in the cell in column F

[Fotis1991]

Apologize. I completely missunderstund what you were asking for. So if this one one does not works for you, then i need a sample workbook with your existing code to test it, or else you have to wait for some other member to offer a suggestion for this.

Please Login or Register  to view this content.

[dragosnb]

thanks for your help! i managed to fix the last code you gave me. It is working and it looks like this:

Please Login or Register  to view this content.

[Fotis1991]

You are welcome and thanks for the feedback.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[dragosnb]

done! thanks once again, you were very kind