Excel 2007 : Drag Formula Down Entire Column

Hello, everybody. Here is my conundrum:

I have this lovely formula that chooses the highest value in cells G, H, and I, populates cell E with them, and adds an additional 183 to the value. It's simple and works beautifully. Except that it adds over one million rows to my sheet (it adds the value "183" to all the blank Column E cells at the end of the report).

Please Login or Register  to view this content.

I was hoping to drag the formula down to the last used cell in Column E, because it would run faster than an array. I just don't know how. This code will be used for multiple reports, so the number of rows will differ on the day to day. Blank cells in Column E, in the middle of the report, are never an issue (there is always a value pulled from G, H, or I). It's the 1 million blank cells at the bottom that are slowing things down.

Can anybody help me achieve this?

Thanks, Ben.

This variation also worked:

Please Login or Register  to view this content.