Now it is giving an error on the line which starts with

ActiveCell.FormulaR1C1 = ...

The error is: Application defined or object defined error (1004)

The formula runs fine in excel. I suspect one of the reson might be where the "_" or breaks are put in (they might be breaking the formula far away) but I am inexperienced with this.

I think I've resolved the first one, but the second one (between lines 3 & 4) isn't clear to me. Is there anyway you can copy the actual original formula and paste that here?

The following is a formatted version of the formula I have so far.

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Out of curiosity, I recorded entering the cell formula in post 37390106. As in your question, the recorder made mincemeat of the formula, dropping bits of it.

I've no doubt that someone will correctly repair Excel's error and give you a valid line of code - however I strongly recommend that you instead split the formula out over a number of cells. When you have to make a change to the formula in a day/week/month you'll be hugely grateful to your earlier self!

Can you do a copy paste of the actual entry of the formula (copy from the formula bar in excel)?

Can you also also not request closing for not receiving an answer within 12 hours on a Sunday night? All experts are volunteers and some have jobs, families, beds, etc.

Glad that worked. Until we saw the original formula, it was very difficult to see what missing characters there were in the second break.

I suspect that this happened because there are more than 256 characters in the original formula (777, including spaces, in fact). This would have accounted for two breaks.

0

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

This worked for me:

Open in new window