Problem with Public Variable value being changed.

[HammerJoe]

Hi,

I am hoping someone will be able to explain and offer a fix for this
problem I have with a worksheet I am working on.

On the module 1 I declared a public variable RowCount as long.
This variable is assigned in the Open function to find the last row of
data.
I then use it in Sheets1 to add/make changes to values on the
specified RowCount Range.

My problem is that somehwere Rowcount value changes somehow.
I have msgbox's everywhere the Rowcount is modified to keep track of
it and I cant find a reason why it changes.

The only thing I can think of is that I have another worksheet opened
that also has VB code and it might mess up with it, but I dont have
any variable called RowCount.

So I need to fix this. How can I protect the Rowcount so it only
changes where it is supposed to (in this case in the module 1 only)
and that it can be used anywhere in that worksheet only (right now it
only have one sheet called "tracker")

Thanks for the help.

 

[RB Smissaert]

Try debugging by putting a watch on that variable and run the code.
This is done in the VBE under Debug, Add watch.

RBS

 

[Chip Pearson]

I would set a Watch on the variable. In VBA, go to the Debug menu and choose
Add Watch. In that dialog, enter RowCount as the Expression, select "All
Procedures" in the Procedures drop down, select "All Modules" in the Module
drop down, and select "Break When Value Changes" in the Watch Type option
box. When the value of RowCount changes, VBA will pause on the line of code
that changed the value.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)