Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 8, 2026
Topics: 61 / Replies: 1588
Reply
Reply
RE: Convert Numbers to Words for General Use

Hi Salim, To modify the code for this type of general use - find these lines at the bottom of the function and comment them out: ' Select C...

6 years ago
Forum
Topic
Forum
Replies: 3
Views: 1163
Reply
RE: Sort weekday names in slicer

Hi Erik, If you've already set up a custom list by going in to: File > Options > Advanced > General then right click on the slicer ...

6 years ago
Forum
Reply
RE: Date Match Inquiry

Hi Steve, without your workbooks it's impossible to write a formula for you! Regards Phil

6 years ago
Forum
Reply
RE: Vba click on the button to download files

Hi Gold, Not being able to see the entire web page makes it difficult to give you code that will work, so I can only go with what you have provided...

6 years ago
Forum
Reply
RE: Vba click on the button to download files

Hi, I don't see how that code will work, URL isn't set to an actual URL? Without the full VBA and HTML code from the web page it makes it diffic...

6 years ago
Forum
Topic
Forum
Replies: 8
Views: 3008
Reply
RE: Change Pivot Table Cache Origin

Hi Cristian, Without your workbook it's difficult to understand exactly what the issue is, or test what is happening. Please, always attach a work...

6 years ago
Forum
Reply
RE: Macro to save to new folder works for me but not others

Hi Netty, Please don't click the Quote button, it just duplicates the previous post. Use the Add Reply button instead. Thx Phil

6 years ago
Forum
Reply
6 years ago
Forum
Topic
Forum
Replies: 1
Views: 1200
Reply
RE: Vlookup for filtered data in VBA

The code does enter a VLOOKUP only for visible cells in AA. If you are getting some other result please attach the workbook again so I can see what...

6 years ago
Forum
Reply
RE: Vlookup for filtered data in VBA

Seems to be, but again, you haven't clearly explained the problem or desired result to I'm guessing. Have you tried it?

6 years ago
Forum
Reply
RE: Vlookup for filtered data in VBA

Hi, I'm a bit confused. I don't know what sheet you want the code to act upon. All you need is a line like this Sheets("PIR Template").Act...

6 years ago
Forum
Page 50 / 110
0