chr

  1. T

    .formula has VBA error when using special characters

    I have an excel macro that loops through table body cells on each worksheet and inserts a cell formula using a combination of text strings. There are three worksheets. The macro works fine on worksheet 1 and 3, but on worksheet 2, the macro errors out with an application-defined or...
  2. A

    Run-time error 438 - Object doesn't support this property or method

    Good Afternoon I'm formatting these large spreadsheets that contain mostly text. I'm trying to find characters used as bullets (Chr(149)) to format them. The code below gives me a run-time error 438 on this line: If .Characters(i, 1) = SearchValue Then I have tested the code by changing it to...
  3. P

    Problem with Split and Symbol Code

    Hello everyone! I`m trying to use a Split for find and replace invalid symbols from my data, as there are A LOT of symbols, doing it line by line seems not correct. I like to use Split for these types of things, but this time it is not working as Split adds "" to the values... This would be...
  4. E

    Can someone explain union , Const and

    Hello people, Could someone explain following terms/declarations or whatever you call it: Const Union Concat Chr I did read some on Microsoft website but I didnt understood. Could someone help me? Thank you in advance

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
Back
Top