international

  1. B

    Changing multiple variations of names into one name

    Hello all, I've heard this is a very helpful group of individuals and hopefully you can help me solve my issue. Also, sorry if this is answered somewhere, I have hard time searching this situation. I currently run a report each day containing training data for multiple companies. The issue...
  2. S

    Networkdays International VBA code to deduct Public Holidays

    I seem to be lost on how to include public holidays in Network Days International VBA function? The below code works fine if no public holidays are involved but if I have some public holidays in a month how do I correct the below code? Cells(a, 85).Value2 =...
  3. T

    COUNTIFS Across multple columns and multiple items per column

    Hello! I am having some trouble that I am hoping to get some assistance. =COUNTIFS(H11:H1000,Q4,I11:I1000,W3) I need to calculate that if UK(Q4) appears in column H and then also count if 9 different options appear in column I. Currently my formula is only for 1 of these options (W3) as I...
  4. A

    International Character (Accentuated) In A Macros

    Guys, I'm having a bit of an issue. In one of my Macros some of the text is international. Namely, there's one Croatian letter within a formula: "U realizaciji (isplaćeno)" And it always translated into: U realizaciji (isplaceno) So from a character with accent, to a normal/ordinary c letter...
  5. L

    Good practices for internationalization?

    Hi everyone I am working on an excel tool which will support German and French users. I want to avoid having to set up all the sheets in two language versions, so I'm looking for good practices to switch languages by other means. For example, I could imagine having a sheet with all static cell...
  6. J

    Reading foreign text in VBA

    Hi, I have foreign (non-English) characters in a cell which I was reading using Sheets("data").Cells(1,1).Formula However this returned nothing but questions marks instead of the text:e.g. ζχψωβνιθςεβφ[ςε turns into "????ί????eίf[?e" After research I discovered I needed to set the regional...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top