Help with writing a simple range programme in VBA

Hi all

I'm trying to teach myself VBA and am trying to build a really simple programme which looks at a range of text data from cell A1 to cell E10, and if the text says 'fraud' then the cell will be highlighted a certain colour.
The code I have written is a mash up from various sources on the internet and I have no idea whether it's suitable or not. I keep getting the error "End if without Block If" which I understand to mean my 'If' instruction is not correct.

Here is my code, could someone please advise me?

Please Login or Register  to view this content.

Hi jembop, welcome to the forums. However, your post does not comply with the forum rules. Please take some time to read the rules.

You should change your thread title to something more descriptive of your problem, and use [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags around your code.

Welcome to the forum.

We would like to help you but first take a look to forum rules and specially in rules# 1 & 3.

Change your title, add code tags and then anyone would be able to help you.

Amended your code with some comments.

Please Login or Register  to view this content.