TM1 Forum

***** Without going into a long explaination on this, using a hierarchy to store these accounts, is not an option here. It seems odd that you cannot use a hierarchy. What is the reason ? Otherwise, your rule could work like this: ['Total1']=N:['Acct1']+['Acct2']+['Acct3']...['AcctN']; But that is a...

I realize that this is probably a simple answer for some of you but I'm stuck on this and can't find an answer in the documentation or an existing thread regarding this on the board, so any help that can be provided would be greatly appreciated. I would like to know how I would go about summing up a...

Nevertheless, I would be interested to see if the filters would perform better; if you'd be interested too, leave a small sample file so that I can write the code and then you can test it on your 10,000 lines. Wim I tried it and found the performance to actually be a little slower, approx 32 second...

No idea why one PC is faster than the other but another optimisation to try is to do a union of all the cells to delete and then delete them all in one go ... This is my code for hiding rows, should be able to do something similar with delete (I've put in the command in a comment at the end). Sub H...

Hi Why not coding the Autofilter or the Advanced filter? (If I understand the problem well). In my experience, with large spreadsheets, this is often a multitude faster than loops. Indeed, first turn off automatic calculation, events, screenupdating and the statusbar if applicable. Wim I understand...

No idea why one PC is faster than the other but another optimisation to try is to do a union of all the cells to delete and then delete them all in one go ... This is my code for hiding rows, should be able to do something similar with delete (I've put in the command in a comment at the end). Sub H...

Before running the delete loop, I would be tempted to add: blnAppEvents = Application.EnableEvents Application.EnableEvents = False And afterward: Application.EnableEvents = blnAppEvents Does that help ? I already tried the enableevents trick, but it had no impact. However, what is the "blnApp...

I have a macro that is cycling through a collection that then utilizes selected members of that collection to flag selected excel rows for deletion. The coding seems to be relatively simple but the issue is this: A.) There are approximately 2000 lines that it has to delete. B.) On 2 of the office co...