Hello Dave,

Well I figure that within an hour, there is a bug , but I could no
access this forum to post my reply.

And problem is in the FOCUS. It wasn't getting focus properly.

What I do is at the beginning of the code I take off focus of all th
other objects on the sheet and make this an active sheet. Then it work
fine.

Other wise I get subj error message. Weird ha?

Another thing I have problem with is when I am using scroll bar t
scroll a chart and on change event trying to update worksheet -- i
seems like it is skipping some of the function calls to update a sheet

What I mean is that sometimes it works sometimes it does not. So thi
is how I fixed it.

Sub ScrollBar1_Change()

Application.Calculate '<< I put this same function twice, and it work
all the time
Application.Calculate '<< second call to this function updates whol
worksheet

End sub

This works fine unless I have around 3000 lines on a sheet, then
really get problems updating twice that kind a sheet takes a long time


May be there is a better way to fix it, I am new to Excel, just coupl
of weeks since I've started this project.

The other problem I get is when I have that many lines on my sheet an
I put functions beyond column GE, they would not work. They work when
do not have that many lines or they work if I put them before tha
column.

For example

I would need to sum all the elements in column lets say HH so I put
function SUM(HH:HH) and I get error. If I put SUM(HH1:HH3000) It works
and it works if I do the same for other column or if I have less lines
about 200. Bugs bugs bugs... everywhere :

--
Intellihom
-----------------------------------------------------------------------
Intellihome's Profile: http://www.msusenet.com/member.php?userid=147
View this thread: http://www.msusenet.com/t-187044591