Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Sep 17, 2025
Topics: 61 / Replies: 1581
Reply
RE: update Old value in another sheet

Hi Vasim, There's no code at all in your workbook, have you tried to write anything? I'm not really clear on exactly what it is you want to happ...

7 years ago
Forum
Reply
RE: Distribution of a value according to a pattern.

Hi Miguel, After looking at your spreadsheet I'm not clear on what you are trying to achieve. Can you please supply an example with numbers and ...

7 years ago
Reply
RE: Add Outlook Signature to Email

Hi Mike, If you have a default HTML sig already set up you can modify just one line of code With OutlookMail .Display .To = Email_To .CC = Emai...

7 years ago
Forum
Reply
RE: File Name conventions in VBA

Hi, If you have posted this qs on another forum please let us know so we aren't duplicating effort. As the answer on the other forum said, wrap ...

7 years ago
Forum
Reply
RE: Drop option for referring

Hi, Both of those lines give me the correct answer for the last row in my data. But I'm not sure what you are trying to do that is causing you a p...

7 years ago
Forum
Topic
Reply
RE: How to convert SBCS to DBCS?

Hi Julian, Yes, whether "MONTH" is stored as a double-byte or single-byte character, it still only has 5 characters in the string. Regards Ph...

7 years ago
Reply
RE: How to convert SBCS to DBCS?

Hi Julian, DBCS is supported in Excel 2013, it says so at the top of the function description, and I've used it in my own Excel 2013. The number...

7 years ago
Reply
RE: How to convert SBCS to DBCS?

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

7 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...

7 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...

7 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

7 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.

7 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...

7 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...

7 years ago
Page 104 / 110