How to write in vba "Between" to specificy values

HI- In the attached test file (this is only part of a huge report but I am stuck in figuring out this step). How I write in VBA "Between" to look in this example at column A for anything that starts from 28 to 32.99 and then when found between those numbers to write on column E "28.00 to 32.99".

I try to wrote it like this but I am not sure what I am doing wrong?

Please Login or Register  to view this content.

Thank you.

Try (untested):

Please Login or Register  to view this content.

Not a problem with the line of code.

Please Login or Register  to view this content.

@ladyj07

Administrative Note:

We would very much like to help you with your query, however your post does not comply with our guidelines

Please take a moment to review how to add code tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have added the code tags for you today. Please take a few minutes to re-read our guidelines and rules that you agreed to when you joined and comply in the future.

You're welcome. Thanks for the rep.