Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Public Variable value being changed.
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Public Variable value being changed.
Try debugging by putting a watch on that variable and run the code.
This is done in the VBE under Debug, Add watch. RBS wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Public Variable value being changed.
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) wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strange problem with public variable | Excel Programming | |||
Public Variable | Excel Programming | |||
Public variable problem | Excel Programming | |||
Public Variable | Excel Programming | |||
public variable | Excel Programming |