Forum

Hi Bala, See attached. The formula in Col J is an array formula that you will need to enter with CTRL+SHIFT+ENTER but does the job: =MATCH(MIN(...

Hi Mike, Running the MyTimer code above shouldn't trigger calculation. hmmmm. Not knowing what you are doing in these workbooks, but judging by...

Hi Steve, I can't see why your code would run any differently on 2019 or 365. Phil

Hi, Do you have XLOOKUP? If so you can use this: =XLOOKUP(G3,$E$3:$E$22,$A$3:$A$22,,1) See the attached workbook. Regards Phil

Hi Ish, Did you follow the link to this post on Conditional Formatting which will answer your questions? Regards Phil

Hi Mike, Without seeing your code I can only guess as to what you are doing. But if you use this Sub then you should be able to work out the tim...

Hi Steve, I can't reproduce the error. When I run VisibleTrue it runs without issue. Do you get this error when you open the workbook? What ...

You're welcome 🙂

Hi Mike, Without seeing your code it's hard to say. Are you using DoEvents? An alternative approach is to just take a timestamp when your macro...

no worries.

Steve, Without your workbook I can't do anything. Phil

Hi Maurizio, So you want to go to this website: Immobiliare.it/Affitto-Garage/Bologna/ and then get the price and area of each listing, for e...

Hi Sean, Try this. regards Phil

OK, try this. Phil

Hi Sean, The attached workbook will send your emails. The sample data has lots of blanks and dates that are not set so these will need to be fixed...