Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 11, 2026
Topics: 61 / Replies: 1588
Reply
RE: Copying Active Sheet in Email Body / RondeBruin RangetoHTML function

Hi Alexandra, You are calling the RangetoHTML function and passing in rng, but rng has no value, hence the error you are getting. Also, whatever...

8 years ago
Forum
Reply
RE: Excel VBA - Userforms

Hi Venkat, The description of the problem is too vague with to many steps to allow me to really put together a solution. You need to supply a wo...

8 years ago
Forum
Reply
RE: Hyperlinks

Hi, When you say 'sheet' I presume you mean 'workbook'? When you link to other sheets, I'm assuming you are linking to sheets in other workbooks...

8 years ago
Topic
Replies: 1
Views: 477
Reply
RE: Excel Hanging

Hi Mohamed, Uploading a 1.55MB file should work fine, I've just tested it to make sure. Please try again, but if you can't get it uploaded open ...

8 years ago
Reply
RE: Excel Hanging

No file attached. Can you please describe the problem in more detail. What exactly are you doing when Excel hangs? It's not clear what you mean b...

8 years ago
Reply
RE: Excel VBA to change placeholders in outlook message template like mail merge

Hi, Without your files to look at it's hard to work out what you code is doing. If you want to change the email address you are sending the email ...

8 years ago
Forum
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...

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

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

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

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

8 years ago
Forum
Topic
Replies: 1
Views: 1342
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...

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

8 years ago
Page 104 / 110
0