Inserting Lines

[GMOODY]

Good morning all

I've got a macro here that subtotals the number of cases and weight for each store in a list of many stores. Each store will have a different number of lines, based on the number of different products they are getting. After I subtotal, I insert rows 1 & 2 and need to write a couple of things in those lines.

What I want to do is insert rows one and two directly below the subtotal rows. I think that the problem is happening in my "INSTR" line close to the bottom of the macro.

Anyones help is greatly appreciated.

Please Login or Register  to view this content.

[6StringJazzer]

I think that the problem is happening in my "INSTR" line close to the bottom of the macro.

What problem? Not sure what to try to fix for you....


At any rate here is a cleaned up version of your code, and there is clearly one problem at the line you mention, see below.

When you record a macro in Excel, the resulting code tends to be cluttered and inefficient. That's mostly because Excel can't guess at what you are going to do next. In particular, it is not necessary to Select a cell then refer to the Selection to operate on it; you can just refer to the cell straight away. This version declutters the Excel macro.

Please Login or Register  to view this content.