Is there a way to designate several cells as array formula without going to each one and CTRL+SHIFT+ENTER? I have a tabel of abotu 25 cells with slightly different array formula, it would be nice if there was an easy way to hit all of those at the same time. It has to be done each day because each day a new file is created for the previous days data.
Just enter it in one, and drag-copy it.
If you can use vba to enter your formulas, you can use the range formulaarray property:
You could record a macro to put each formula in each cell, assuming all the formulas are slightly different as you say.
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks