Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Sep 17, 2025
Topics: 61 / Replies: 1581
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...

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

7 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

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

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

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

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

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

7 years ago
Forum
Reply
RE: Please let me know how to set page number 1 and onwards from page number 2 of the document. That is excluding the first page from the numbering.

Hi, You need to put a section break between the page you want to start as Page 1, and the previous page. Then set up page numbering as normal in...

7 years ago
Forum
Reply
RE: Vlookup net

Hi David, When posting a macro enabled workbook please don't password protect the VBA modules. The first thing I do when I download an xlsm is ope...

8 years ago
Forum
Topic
Replies: 2
Views: 270
Reply
RE: meal allowance

Hi, I'm not sure I have enough information to give you the formula I think you are after. Isn't the formula simply 3.5 * $35 ? Are you after som...

8 years ago
Reply
RE: Advice how to convert excel with multiple sheets calculations into HTML for WordPress website

Hi Andrew, Have you looked at this post about embedding workbooks in a website? Embed Excel Workbook in Web Page It might be what you are aft...

8 years ago
Reply
RE: calculate num of days

Hi, I'm sorry but it's not clear to me what you want to achieve. Do you have a sample file? How/why does a month have 22 days? If you exclud...

8 years ago
Reply
RE: Insert Data From Calendar Userform to Sheet 1

Hi, I'm not entirely sure what you are trying to do. But I looked at your workbook and I'm guessing you are trying to get the calendar in your for...

8 years ago
Forum
Page 105 / 110