Program resets by itself

[ajsivsan]

This code looks simple but it is causing me trouble.

Cells(1,25) = Cells(1,25) + 1

All i wanted is to increment the cell value by 1. The cell has an integer value. It was working fine till yesterday and today when i execute the code, it resets the program and the program starts from the beginning.

Also another strange behaviour is that when i have my laptop connected to my dock everything works fine. But when i remove from dock, the VBA Button in my sheet increases in size for each press and if i try to reduce the size, then the text in the box reduces in size for each click...

Guys please help me how to resolve these..

Thank you.

[MarvinP]

Hi ajsivan and welcome to the forum,

Cells(1,25).value = Cells(1,25).value + 1 ?? Might help.

What if there is text in the cell? What happens then?

[ajsivsan]

What i am trying to do here is, when a new row is inserted, the key field will check for dupliates. if the new entry is a duplicate of previous entry, then it will display a msg box telling that it is a duplicate entry. Else it will display the no of rows inserted/deleted. When the code hits the highlighted line, it resets itself from the beginning.

The cell will have the row count each time the sheet is activated. So there is no chance of any text over there.

Please Login or Register  to view this content.

[ajsivsan]

It got solved when i changed to another cell.