Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 11, 2026
Topics: 61 / Replies: 1588
Reply
RE: How to convert SBCS to DBCS?

Hi Julian, ASC converts DBCS so SBCS DBCS converts SBCS to DBCS. Cheers Phil

8 years ago
Reply
RE: Sumproduct formula for filtered Pivot table getting #Ref! error

Hi Mitul, Everyone who responds to a question on this forum is giving up their time to help out. When you ask for Anders to 'explain me each &am...

8 years ago
Reply
RE: Protect Workbook from name change

Hi David, It is possible to do something like this but there are a few issues with this approach. It relies on the person opening the workbook t...

8 years ago
Forum
Reply
RE: Formula used in excel

Hi Ravindra, I don't really know what you mean. Can you explain in more detail and supply a sample workbook? Regards Phil

8 years ago
Forum
Reply
RE: Problem in tiles and duplicate value when using index and match

Not sure what happened but I have reattached the file so you should be able to download it now.

8 years ago
Reply
RE: Insert a Pdf Document in an Email

Hi, Your original post said that your email client does not have to be Outlook. Not that it is not Outlook. VBA only works with Microsoft Off...

8 years ago
Forum
Reply
RE: Can Minute or Time formula be used to calculate minutes between two times from only one cell

Hi Mitul, Please always provide a sample worksheet if possible. If you had done so in this case Frans would have understood what you were trying t...

8 years ago
Reply
RE: Defines a code to trigger a column in places in a sheet

Hi Lea, I now realise this is the same qs you asked in the General Qs & Answers and Mynda replied telling you that Data Validation lists was th...

8 years ago
Forum
Reply
RE: Defines a code to trigger a column in places in a sheet

Hi Lea, No problem. It sounds like you need to use a data validation list. I can see there's some VBA in the workbook but you don't need any of t...

8 years ago
Forum
Reply
RE: Defines a code to trigger a column in places in a sheet

Hi Lea, Sorry I don't understand what you mean. Can you rephrase the question or explain the process you are trying to achieve? Regards Phil

8 years ago
Forum
Reply
RE: Time Clock

Hi Charles, Sorry for the slow reply. Attached is a workbook with a couple of subs that control the timing. Just click on Start and Stop. The ...

8 years ago
Forum
Reply
RE: Need help how to set up smtp A/C for gmail for Apple Macbook computer without having outlook ?

Hi Mitul, This is an Excel forum, please only post questions related to Excel. Macs have a built in email program called Mail, you can use that....

8 years ago
Reply
RE: Need help with IF, AND, OR formula

Hi Sajil, Can you provide a sample workbook with data and formulae? It's not really clear what it is you are after. Where is the ROUND formula ...

8 years ago
Reply
RE: Run-Time Error 53 File not found

Hi Ken, It would appear that when you read the sig file in, and then add it as part of the HTML body of the email, Outlook is messing up the links ...

8 years ago
Forum
Reply
RE: Run-Time Error 53 File not found

Hi Kenneth, Testing this code I also get an error at the same point because the file C:UserspgtAppDataRoamingMicrosoftSignaturesDefault.htm does no...

8 years ago
Forum
Page 105 / 110
0