Clear range based on cell value - clearing cells out of specified range

First post (in a long time)! Hello everabody!

I'm working on a number of interconnected spreadsheets that perform a variety of calculations and decision making for a manufacturing company. Right now I'm pretty close to next release on the quoting/estimation portion of my project, my first time using VB.

The issue is illustrated in the pictures I've attached. In image 1 you can see 6 items on my quote sheet, which is an excel worksheet. You can also see that I've entered the number "3" into the cell in the upper right next to the delete button. My code runs pretty well, but with one issue...
1.jpg

My 5th item, and it's always the 5th item, clears out the qty and $ea. If I'm deleting item 5 or any item above it, those cells (D26:E29) are blank. There are no formulas in this worksheet, only 2 different subs. One to delete the entire quote, and another to delete an individual item, which is done simply by deleting (with xlshiftup). The items are placed on this sheet from a different worksheet in the same workbook that serves as the user input/item configuration user form. If I delete any item 6 or over I don't get any errors - the code and spreadsheet performs exactly as I expect. There are no references to D26:E29 anywhere in any of my code on any of the sheets in this book.
2.JPG

The 3rd worksheet involved is a data bank that I use to store all the fields to define an item so that the user can copy any completed item and edit it as a new item, or pull up one of those items to edit it. The entry on these sheet is also cleared out when the user deletes an item. I've had no problems on that page with items losing data inexplicably.

Please Login or Register  to view this content.

I'm open to unrelated coaching on my code (and the indentation, as I'm not sure what the best way to indent is). I can track where I am in this stuff though, so I guess it isn't THAT bad...

Eventually I'm hoping to move all of the user interface into a program that still uses the spreadsheets for their data, decision logic, and calculations. (I'm open to talk to talented programmers if you're interested)

I'd give more information, but I'm not sure what you'll need/want. There's no interactions on this quote page other than what you're seeing here, so I'm not sure what else I could show you.

Thanks in advance!!
-Jason