Code Issues: Throws error everytime I add a row

**jaredmccullough** · 05-08-2014, 08:01 AM

I have used to following code to self adjust cells within a WS based upon the output in others. The issue is that when I insert a new "Blank" row I get an error code everytime. I understand why I just don't understand how to fix it any suggestions would be appreciated:

Please Login or Register  to view this content.

**GC Excel** · 05-08-2014, 08:12 AM

Hi,
Try this :

Please Login or Register  to view this content.

Trick is to perform the code only if ONE cell is changed so if Target.Count = 1...

**jaredmccullough** · 05-08-2014, 11:12 AM

Originally Posted by GC Excel

Hi,
Try this :

Please Login or Register  to view this content.

Trick is to perform the code only if ONE cell is changed so if Target.Count = 1...

GC seems to work can you maybe explain what the issue was just for my knowledge.

Thanks for the help

**GC Excel** · 05-08-2014, 11:52 AM

When you insert a new row, the Target address is the full row (example $15:$15), not a single cell.
Therefore, you can not use the Select Case to verify the value.