Ok...I've broken the 2 sub-routines and assigned the click event on 2
different buttons and everything works.

I'm thinking the cells aren't getting refreshed when I do it programically
and that's why it returns zeros. Is there some way to force the cells to
update?



"B Lynn B" wrote:

post yr code plz. pretty hard to tell what's going on otherwise.

"Jeff" wrote:

I am using EXCEL 2003 and I've got a workbook that has been working. Part of
the functionality is that it goes out to a SQL database and imports a subset
of data onto a sheet in the workbook. There is a summary sheet that I'm
using to organize the data subset.

I'm using a couple of Domain Aggregate functions (DCount and DCountA) to sum
the total rows of data and the total non-blanks rows of data. This is all
working great.

What I want to do now is - on a separate worksheet - capture the summaries
by day so that I can display a trend chart on a rolling 30 day window.

I've created 7 variables in my subroutine (one for date and 6 for the
individual data values I want to trend) as Var1, Var2, Var3, etc and I'm
setting these values equal to the cells in the summary sheet that it's
normally found.

My thoughts were that once I've set each of the variable to it's respective
cell on the Summary sheet, I could just right those values onto the sheet
that will store the data for the trend chart.

What I'm find is that when I run the macro it puts the date in the correct
spot and all other data fields are equal to zero. If you check the summary
page there are non-zero values there.

I accidentally discovered that if I put a break in the code, the Vars
eventually get populated with the right values and subsequently the storage
sheet gets the right values. It's almost like the subroutine gets done
running before the cells get updated on the summary sheet.

And FYI I'm doing this with 2 different sub-routines. The first routine
populates the fields on the summary page and the last line of that sub calls
the other sub which is supposed to populate the sheet for the trend chart.

I'm missing something simple I suspect.

Thanks

Jeff