Text problems

  • Thread starter Thread starter bambam77
  • Start date Start date
B

bambam77

I wrote a macro that takes information from a database, couts and sort
it, and makes a pareto graph out of it. The program was working fin
until I made the database read only. When the database is updated, th
macro opens it using the writers password, updates the database, an
then does a save as. I click yes to replace the old file with the sam
name.

Now when I try to run my macro, the formulas don't work for instance
have =COUNTIF(A$2:A$374,"RM01") in one cell and it wont recognize th
text RM01 anymore. But get this, ith I highlight the text "RM01" in th
formula, it works again. Can anyone help me and tell me what have
done? I need help in a major way.

By the way, I'm new at VBA programmin
 
I wrote a macro that takes information from a database, couts and sort it,
and makes a pareto graph out of it. The program was working fin until I made
the database read only. When the database is updated, th macro opens it using
the writers password, updates the database, an then does a save as. I click
yes to replace the old file with the sam name.

Now when I try to run my macro, the formulas don't work for instance have
=COUNTIF(A$2:A$374,"RM01") in one cell and it wont recognize th text RM01
anymore. But get this, ith I highlight the text "RM01" in th formula, it
works again. Can anyone help me and tell me what have done? I need help in a
major way.

By the way, I'm new at VBA programmin
Click to expand...

--
Message posted from
http://www.ExcelForum.com
Click to expand...

I have run into this problem also. Even calculating the sheet will not make
it update. In my case, I am using names in my formulas and if I select the
cell and then click in the formula bar and then hit enter it will update.
The other method I used was to have code re-paste the formula every time a
row was added to my database.

Dave
 
I am assuming this is some kind of glitch in Excel then. At first
thought it was a formatting problem. I will try the route you took b
using code to repost the formulas. Thanks for the feedback
 
Back
Top