Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 10, 2026
Topics: 61 / Replies: 1588
Reply
RE: horizontal scroll bar have become very small like I fill a huge number of column with data

Hi, I don't have the same issue when I insert an ActiveX button. Please supply your workbook so we can have a look. Regards Phil

6 years ago
Reply
RE: Target Achievement

Hi John, I've reattached the file, please try again. Phil

7 years ago
Forum
Reply
RE: Filtering out non english data from cells

Hi Leeroy, there is no file attached. Regards Phil

7 years ago
Reply
RE: 4 types of inputs

Hi Stefano, that file isn't intended for circulation as it was for illustration purposes but here it is. Regards Phil

7 years ago
Reply
RE: Vlookup + Left Problem

LOL Anders. I have the same issues when switching between VBA, PHP and JavaScript.

7 years ago
Reply
RE: Vlookup + Left Problem

The function to check for the length of a string is LEN, not LENGTH 🙂 regards Phil

7 years ago
Reply
RE: Scrape Data

Hi Ian, If you look at the source code for that page you'll find this bit for the State Code <select name="pv_state_code" class="form_data_...

7 years ago
Forum
Reply
RE: Macros for highlighting max min values

No worries. After the set rng statement modify your code to this rng.Interior.ColorIndex = xlNone For Each zelle In rng If zell...

7 years ago
Forum
Reply
RE: Macros for highlighting max min values

Hi Chong, See attached workbook. Regards Phil

7 years ago
Forum
Reply
RE: Macros for highlighting max min values

Hi, Can you supply the workbook please. Phil

7 years ago
Forum
Reply
RE: Macros for highlighting max min values

Hi Chong, Do you have to use VBA? have you tried Conditional Formatting? Regards Phil

7 years ago
Forum
Reply
RE: Open OWA from Excel

Hi Tim, The articles are referring to Outlook on Office 365. I assume that's what you are after? Yes unfortunately to get Excel to connect and ...

7 years ago
Topic
Forum
Replies: 4
Views: 2916
Reply
RE: Open OWA from Excel

Hi Tim, I haven't done this myself but you can do this It does not appear to be a trivial process. Regards Phil

7 years ago
Reply
RE: Filter Not Working

Hi, there's no file attached. Regards Phil

7 years ago
Page 84 / 110
0