Search results for query: *

Hi I need to rollout the same personal macro workbook to a number of users. My current approach is to have each user run an install programme once that extracts the file to the diretory it needs to be in: C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel\XLSTART They can...

The code looks at the contents of columns A - E on sheet1 and compares them to a set of rules (ma character length, does B contain http: or https: etc) defined in the macro. If they don't meet these conditions, the offending row should be moved to sheet2 and a message stating the problem placed...

I can't actually post the code because (owned by my employer etc) However I've just found the smae problem with another macro, this time across 2 PCs. So it's got to be something more than just one set of code.

Hopefully somebody has come across this problem deploying macros on multiple PCs. I've got a macro that runs fine on a colleague's PC. But on mine (same OS, same Excel version and service pack) it runs differently - namely it doesn't paste some data from sheet1 to sheet2. I suspect there is a...

Hi I need to build a number of macros into Excel permanently for a number of users to use for any spreadsheet, so they can access them via a button on the toolbar and/or menu item. However, I need to do this without storing the macros in spreadsheet if possible. So is there a way to build...

Unfortuantley the holidays data with Outlook (2k version at least) is out of date - update is here http://microsoft.com/downloads/details.aspx?FamilyID=7d4d9017-8d4e-4963-8ba7-d2e91d491f5e&DisplayLang=en Close Outllok, install it, then do the steps described in above post. More info on this...

Thanks. The one place I didn't look was Outlook itself. D'oh!

Hi All Has anybody come across a free/low cost add-in which automatically updates the Outlook calendar with official public holidays? I need this for the US, and major EU countries. I couldn't find one on microsoft.com, but I may have missed it...

Thanks everyone for the help . In this case the code was the most useful as I need to add it into a macro I hava managed to record and edit myself - this part was the stumbling block (I should have said). Ref. commenting code, it certainly does help me learn; I've been commenting every...

Hi I've been trying to write code that will fill down a formula in F1. It needs to fill down for the same number of cells that have values in Column C. So if there were values in C1-C256, the formula would automatically fill down in F1-F256. I know it needs an IF argument but I don't have...

Cheers all for this - hope to do a FAQ one day on manipulating text in Excel. Will include this & post to the site.

Hi I've got lots of sheets with text in cell A that has spaces at the start/end/both, of the text. Currently I can remove this by pasting into Word, justifying into the centre, to the right and then to the left (the only clumsy solution I've found). I'd like to either use a macro to do this...

A couple of days have passed, I've learnt some code and can answer my own question. The below code runs across the active sheet on all cells. Sub RemoveLiveLinks () ' This macro removes any hyperlinks, so they become normal text and when clicked don't open a webpage ' It runs on every cell...

Excellent - worked first time. Cheers.

I want to be able to automatically change the text colour to red if the user types more than a set number of characters (including spaces). So if I set the limit was 75 for D1, I'd want the text to go red if they typed 80. I've seen this done, I think without a macro, and can't find any data...

Is there an easy way to remove all the hyperlinks in a sheet in one easy go without cutting and pasting the column into notepad? I know how to remove individual links, but can't find anything about cleaning away all the links in one easy go, so I guess code is required. Suggestions anyone?

Hi Skip That copies the columns ok - but I need a slight change (sorry to move the goal posts) It needs to compare sheet1 column A with sheet2 column A, and if there is a match between them, CUT the contents of the sheet2 row (columns A-E inclusive) to sheet3. Then it needs to cut the...

Ah, fixed it myself - I stupidly pasted it into sheet1 in VB Editor, not workbook. But, when there is a match between a cell in column A on sheets 1 and 2, it's not copying the value from sheet2 column C onto sheet3. It's not copying column B or D either from sheet2. Hw do I add this in...

Thanks SkipVought - but I'm getting an error: Visual Basic 400 Any ideas what's wrong? (Sheets are called sheet1/2/3)

Hi I'm new to VBA programing and don't know where to start with code to do this: User has pasted old values on spreadsheet1, and new values onto sheet2. 1) Need a macro that: - compares contents of each row on sheet2 column A, to sheet1 column A (not case sensitive) - if the contents of a...