Forum

Hi Paul, Because the IF statement will only evaluate until it finds a True condition you can use this, leaving out the AND's, by making your first ...

Hi Kat, You can't do that, it's what's called a circular reference. But if you explain what you are trying to do maybe there's another way. R...

Hi David, What exactly is the issue with getting your avatar photo uploaded? Phil

Hi, The syntax for SLOPE is =SLOPE(known_ys, known_xs) so you can just get the slope from, for example, sheet 44947 using =SLOPE('449447'!R2:R19,'...

Hi, Do you need the VBA to create the chart and trend line, or just get the x coefficient from the trend line on each sheet? Regards Phil

Hi Vinod, When I try to run your code it takes forever 'Contacting the server ...' and I eventually stopped the query. I wrote a new web query a...

Hi David, Yes, it'll keep going until it encounters a blank cell in Col B. Regards Phil

Hi Vinod, I can see that you are trying to get something from the NSE website but I don't know exactly what it is you are trying to do. Please g...

No worries Yousef. Maybe when we're all out of lockdown you can buy me a take-away 🙂 Don't be afraid to try some code modifications. You can alw...

Forgot to say that the code uses FSO (FileSystemObject) so in order for it to work you'll need to set a reference in the VBA Editor to the Microsoft S...

Hi David, Attached is some code that will create a folder structure based on the contents of the sheet. You can probably work out for yourself how ...

Hey Yousef, Did you try doing that yourself? 🙂 It only took another IF .. THEN statement - see attached. Regards Phil

Hi, Can't see any reason on the face of it why it wouldn't work inside a Citrix session. But I don't know what restrictions are in place in your s...

You're welcome Yousef. Not sure what is causing your bugs without seeing the code you have changed. Could be invalid characters in the filenames...