OzGrid Free Excel/VBA Help Forum

Glad to hear you found a 'working' solution

Thanks a lot for your Thanks AND for the Like 

Hi,

Have you managed to fix your problem ?

If not, feel free to attach a sample file in your next message.

A tiny code modification will very probably solve it quickly

Glad to hear you like it

Thanks a lot for your Thanks AND for the Like

As far as decoding the formula is concerned, you can easily decipher it with these few steps :
1. Place yourself in Edit Mode with F2
2. Highlight a section of the formula, say,…

Carim,

Thanks so much for taking the time. The new *2 part works great and my super long formula was is manageable now, not sure how to decipher but it works. Thanks again.

Hi again,

Should you need a compact solution with no list, then following Array formula could help :
(Code, 1 line)

Do not know which Excel version you are using ...

But, prior Excel 365 / Excel 2021, you need to use simultaneously the three keys Control S…

Hi and Welcome to the Forum

In order to try to help you, it would be a good idea to post your macro

I have a problem in Word. In a report I have several headings that are formatted and numbered in word.style "U4". ( Example "3.4.1.1 Headline"). The macro is supposed to list all headings including the number as plain text on the last page one below the…

Hi again,

Should you need a compact solution with no list, then following Array formula could help :
(Code, 1 line)

Do not know which Excel version you are using ...

But, prior Excel 365 / Excel 2021, you need to use simultaneously the three keys Control S…

Glad to hear you found a 'working' solution

Thanks a lot for your Thanks AND for the Like 

Thanks immensely, Carim. It worked like a charm