Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Gracie Hughes   on Mar 04 In MS Office Category.

  
Question Answered By: Luisa Fischer   on Mar 04

Since I started this topic, everyone prevented me from writing
functions, because they seemed to slow down thing so much!
For me time was not a factor before!

Now I am almost begging for permission to use a VBA function once in
a while:-)
In the spreadsheet for my own use, (there is absolutely no VBA in it)
I've been using daily it for years there are much MUCH more formulas
to calculate beside lots arrays, and it really slows down terribly.
So one in a while, I go over the formulas  that have been used and
just keep track of previous downloaded data, and I copy paste them.

Still it takes almost 15 seconds to close the book, and very often I
have to wait quite a while before being able to write something in
the book, because Excel make its safety copy.)

In this case, it might not be that bad. there is just one such array.

It was also by curiosity, I would like to see if I would be able to
program it, because I am learning.

Share: 

 

This Question has 26 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Worksheet functions in VBA Or get search suggestion and latest updates.


Tagged: