OzGrid Free Excel/VBA Help Forum
The best online resource for all your Excel & VBA requirements
Recent Activities
-
algaeginger
Reaction (Post)Glad to hear you found a 'working' solution
Thanks a lot for your Thanks AND for the Like -
Carim
PostHi,
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 -
Carim
Replied to the thread Adding one more variable to an IF statement Formula.PostGlad 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,… -
SkateRockandRoll
Replied to the thread Adding one more variable to an IF statement Formula.PostCarim,
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. -
SkateRockandRoll
Reaction (Post)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… -
Carim
Replied to the thread Loop for extracting headlines of Word document.PostHi and Welcome to the Forum
In order to try to help you, it would be a good idea to post your macro -
janpow
Posted the thread Loop for extracting headlines of Word document.ThreadI 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… -
Carim
Replied to the thread Adding one more variable to an IF statement Formula.PostHi 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… -
Carim
Replied to the thread Delete Column in worksheets containing text.PostGlad to hear you found a 'working' solution
Thanks a lot for your Thanks AND for the Like -
algaeginger
Replied to the thread Delete Column in worksheets containing text.PostThanks immensely, Carim. It worked like a charm