function gets no value in the watch window

[MaartenRo]

Hi,

I wrote code to delete a selection of data beloninging to the last month. I use a countif function to count the amount of rows that should be deleted. Somehow this function doesn't get any value. What am i doing wrong?

Any input is much appreciated!

Please Login or Register  to view this content.

[rorya]

How and when are you testing the value?

[MaartenRo]

in the "lokale variabelen scherm" (dutch), the screen that shows the variables and the dimensions.

[rorya]

And when are you checking it?

[MaartenRo]

Before i execute the sub with mutiple F8's i open the lokale variablen venster.

After i changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

The problem was solved. Any ideas how this can be?

[rorya]

No. Assuming you had actually executed the line, the variable should have a value even if it’s just 0