Recent content by avandale

Hi, I have a named range on a spreadsheet, listing employee names. When any changes are made to cells within this range (A single column with 150 rows), it triggers a sub procedure that has no relation to it. I know of the worksheet_change event, but don't have one associated with this...

Hi, I have a spreadsheet with 28000+ Merchant Names that need to be grouped by their Company. The trouble is, there are no spaces between the individual words the make up the listing e.g. VodafoneDublin VodafoneGalway VodafoneNewYork VodafoneSydney etc. There are about 500+ merchants, each...

I'm working with a Userform and a spreadhsheet to create an Employee Absence Tracker. In column A of the spreadsheet, are the days of the year. Across the top row are the names of employees. I want to select a name on the userform (populated by the employees row) and the date of an absence...

Hi Guys, Using VBA for Excel 97, I'm using the "followhyperlinks" thread to send an email to a recipient. This inserts a specific address to the recipient box. Does anyone know how to include a specific subject in the subject header?

Hi, I'm using an adapted version of a macro to parse names into two columns, a forename & surname. Now it works, but every time I run the macro, I get a dialog box asking if I want to overwrite data in the destination cells. But the destination cells are blank, but would have had data in them...

Thansk Leighmoore, It worked like a charm!!!

Hi Guys, I'm using a VBA form in Excel to access staff absence files. At the momnent, I'm using the ".add item" piece of code to add a name for each person, so that they can be accessed using a drop list on the form. Is it possible to reference a named range in Excel, so that when...