Forum

Hi Tim, What version of Excel are you using? If I divide an array by another array with a 0 in it, the only #DIV/0 I get is in the position corr...

Hi Mark, Please see attached. This code is taken from here VBA Progress Bar I've rewritten the code to be more adaptable, so that when initi...

Thanks Kurt 🙂 I'm using VS Code but only for the sake of taking the pretty pictures. I copy the VBA into it and take the screen shot. Unfortun...

Hi Ramzan, That is a big task, you should start with the scraping posts I linked to above. Then maybe check our Dashboards course for presenting...

Hi Declan, I've written some VBA that will do this for you Show Report Filter Pages for Power Pivot PivotTables Regards Phil

Hi Ramzan, Do you want to scrape the data from this site and present it in Excel, or do you want to write your own system where it takes a keyword ...

Hi Mark, Can you supply the workbook plz? Phil

😉 no worries

Hi Maggie, See attached. To run the code, click into a cell where the text is that you want to check e.g. A1 then click the blue button 'Color W...

Hi Steve, In lstLookup_DblClick you have this loop cNum = 11 For X = 1 To cNum Me.Controls("Reg" & X).Value = findvalue ...

Hi Helen, You can use Conditional Formatting to do this, please see attached. The first thing to do is change the Timestamps into numbers, they ar...

Hi Steve, What about this? Sub InitSub Me.cboSelect.List = WorksheetFunction.Transpose(Sheet5.Range("AA5:AB5")) With Phonelist1 With...

Congrats.

Hi Helen, No file attached! What version of Excel are you using? regards Phil

Hi Charmi, Welcome to the forum, but please read this I moved your qs to its own thread rather than leave it tagged on to a resolved qs from over...