LinkBack URL
About LinkBacks
Hello everyone
I have this code that works well but took a long time with large data
Any ideas how to make it faster?
Please Login or Register to view this content.
Hello everyone
I have this code that works well but took a long time with large data
Any ideas how to make it faster?Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
why are you assigning .value = .value ?
that seems to me like saying 1 = 1
.value = .value changes a Formula in a cell to the result value.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
As a sidenote, is there a reason to do this in VBA in this specific way? I am no expert on pivot tables, but this type of problem (sum the values for several account numbers over a range of dates) seems like the perfect problem for a pivot table to solve. Pivot tables also tend to function very quickly.
Originally Posted by shg
Mr. AlphaFrog
That's exactly what I need .. It is very faster and the results are perfect
Thank you very much for this great help
MrShorty
I'm sorry I didn't notice your post.
In fact I am not good at using pivot tables or you may say I don't prefer it although it is very powerful
Thanks a lot for sharing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks