convenient

Hello guys, I have a file at work that has interesting functionality. It has a minimize set up for each month that you can expand to see per day. It's very convenient and i would like to replicate it, but I'm not sure what to even google for, maybe you have some ideas? Image of what i mean can...

I’m trying to avoid lengthy IF() formulas by using Boolean operators. Is the a more convenient way to return a text string from a cell based on a True/False result that doesn’t involve an IF function? Numbers are easy because you just multiply them by the true/false result.

Hi, I want to create a hyperlink in cell "A1" to a text file. My question is how can I embed the text file with the excel document. I don't want to worry about losing the text file. I want the documents all in a single location which is more convenient for me. I'm not concerned with the...

Greetings, I would like to add a range of columns to a collection and then use the collection in a for each loop including each column-element in the collection in a procedure. like, Dim i As String For Each i in col Is there a more convenient syntax than something like col.add F I would...