generates

  1. S

    Parse JSON into Excel

    Hi I have been using the Jsonconverter vba parser available via https://github.com/VBA-tools/VBA-JSON to extract the data from json files such as https://stats.europeantour.com/v1/season/2019/players/strokes-gained/off-the-tee. This has been very easy to set up and it works. However, the...
  2. E

    Is this a bug?

    Hello When I try to copy a sheet I get the following error, which no matter what I click, does not go away (it actually generates tons of such messages with different name) i.ibb.co/BwffP3p/Capture.png Any idea please?
  3. J

    Center a character automatically based on the formula

    Below is the formula. I was wondering if there's a way to make the asterisk center in the cell instead of being at the top so that it's perfectly inline with the value that generates from A!D10 =IF(A!D10=100,A!D10,A!D10&" *")
  4. I

    RAND Between

    hi guys, Two cells question with random numbers formula: In A1 I have random number generator in a range from 1 to 99. = RANDBETWEEN(1,99) In B1 I want to add formula which would fluctuate values from A1 but within a certain range. So I have in B1 this formula: =A1+RANDBETWEEN(-25,25)...
  5. E

    VBA - Write after the last row with content

    Hello, I have code which generates table blocks of different sizes. You have for instance blocks in the following ranges: D19:F45; H19:J31; L19:N36 I am writing a loop which generates blocks underneath the 3 blocks stated above. If I wouldn't know how big the three blocks are and I would want...
  6. M

    Complicated formula to dissect a name into multiple columns

    Hello, I've found a few formulae to do close to what I'm looking to do. Short story: I have a report that pastes into an excel "tool" that then digests information and merges it into a word form via mail merge. It generates as many as 1000 forms per day, so it's important to get things...
  7. M

    Supress zero on Table Chart

    I need to suppress data points that are zero on a chart linked to a table. I have achieved this with a standard chart using NA() in the IF statement that generates the data to be charted. The NA() generates a #N/A in the data which a standard chart ignores, this does not seem to work with a...
  8. P

    Collection - add

    Hi two versions, one works, second one gives: Compile Error, Expected: = 1) CollectionName.Add cell.Value, CStr(cell.Value) 2) CollectionName.Add(cell.Value, CStr(cell.Value)) What is the difference? Why the second one generates an error Thanks

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