generates

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...

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?

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&" *")

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)...

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...

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...

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...

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