Forum

Hi Paul, You cannot identify the color of a Condtionally formatted cell, not even with vba. But you can evaluate the same formula used in that cond...

Hi Celeste, Try attaching the image again, we cannot see it.

Hi, The MailTo hyperlinks are working on my computer, was able to use your file. Check if Outlook is the default application associated to MailTo l...

Hi Hans, You don't really need formulas, forget about old excel habits and think in Power Query. You have many ways to do that, without even writin...

Hi Tim, That should be handled from the software you are using, not from excel, That application is handling office documents through its specific ...

You have to be careful to the date format you build: I used "01/" as the first part of the string, and obviously it should represent the missing part ...

Hi, You can control everything the user does in that form. Check our file for an example. If you want to have a specific data format for a te...

Hi Eduard, You can use the text functions to build a valid date, then format it: =Date.ToText(Date.From("01/"&Text.End([date],2)&"/"&...

Catalin Bombea said Parameters: xlSheetVisible=-1 xlSheetHidden=0 xlSheetVeryHidden=2 If you're using the value 0, you're just switchin...

Hi Alexandra, Visible is a property of the worksheet object, not a feature. You can place the code in any sheet module you want, or in a regular mo...

Try an if conditon then, if you don't like the response types: if [2]>0 then [1]/[2] else 0

Hi, Use: ThisWorkbook.Worksheets("Sheet1").Visible=2 ' xlSheetVeryHidden Parameters: xlSheetVisible=-1 xlSheetHidden=0 xlSh...

It's much easier in Power Query than before 🙂

Hi Celeste, Use: try [Column1]/[Column2] otherwise 0

Yes, it's an old problem. Usually, a good firewall and site settings does most of the job, no need for specialized software like:Large sites do need s...