Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 11, 2026
Topics: 61 / Replies: 1588
Reply
RE: Upgrade Excel 2010 to Excel 2013

Hi Kevin, Seems that since 2013 you can't choose which programs to install, at install time. However you can use the Office Deployment Tool to con...

8 years ago
Reply
RE: Upgrade Excel 2010 to Excel 2013

Hi Kevin, Microsoft don't recommend it, however I have had more than one version of Office installed on a PC - but generally run into some problems...

8 years ago
Reply
RE: Social websites extraction

Hi, Please check this post Regards Phil

8 years ago
Forum
Reply
RE: VBA For Show DataForm

Hi Irfan, So you want to display a form whilst Sheet1 is active, but the form loads data from a sheet called Data? It doesn't matter what sheet ...

8 years ago
Forum
Reply
RE: Digital signing of macros

Hi Peter, When you say Excel can't 'see' the certificate what exactly do you mean? When you try to add the cert in the VBA editor are you gettin...

8 years ago
Forum
Reply
RE: Run Time Error Method 'Value' of object 'Range' failed

Hi Irfan, Please supply the workbook with code+form so it is easier to help you. Regards Phil

8 years ago
Forum
Topic
Replies: 1
Views: 432
Reply
RE: How to Fix "Invalid Property Value" Error Message ?

Mariya, Are you actually uploading the file from your PC or are you providing the URL to Dropbox when trying to load the file to the forum? I hav...

8 years ago
Forum
Reply
RE: Social websites extraction

Hi, See attached workbook for a good start on this. The code in the workbook will load a page and then parse the HTML for any links. It will p...

8 years ago
Forum
Reply
8 years ago
Forum
Reply
RE: Matching three cell data with one cell data - different pattern

Hi, There isn't any consistent pattern to be able to match. The first line is the name Adam Moore and you are looking for the pattern adam.p.moore...

8 years ago
Forum
Reply
RE: Copy & Paste with Merged Cells Above and Below

Thanks for letting us know you worked this out. Phil

8 years ago
Forum
Reply
RE: ForeColor.Brightness

Hi, Was this originally created using the macro recorder? I ask because I've read that the VBA recorder will include a setting for Brightness, b...

8 years ago
Forum
Reply
RE: Matching three cell data with one cell data - different pattern

Hi, There is no sample document. Please try uploading it again. Thanks Phil

8 years ago
Forum
Page 102 / 110
0