Recent content by WingandaPrayer

Thanks both for the different solutions.

Hi all, I'm looking to take out the commas from a cell except for the first instance? I couldn't find anything via the keyword search. e.g. 10, Downing Street, London, SW1A 2AA to 10, Downing Street London SW1A 2AA Many thanks.

When using the import option from within Outlook 2003 to load appointments from Excel is it possible to automatically email the required attendees? I've mapped rhe following fields; Date, start and end times, subject, description and also added in the email addresses to the required attendees...

Thank you, that's done the trick. [smile]

Hi, Is it possible to lock just the sheet tab in a worksheet to stop someone else renaming? Many thanks.

bump :-D

Hi all, When using Word 2003 to mail merge, is it possible to automatically change a numeric field to Text? The merge field comes from a Progress program and not excel. Thanks in advance

Hi all, If you would give me some advice please. I'm mail merging from a Progress program into Word. I was using the word field IF option when a merge field was 'not blank' the £ symbol would be placed before the field. When the field was blank it obviously wouldn't show and the next line...

Thanks

Hi all, When filtering in Excel the drop down arrow shows blue if the filter is in use. When not in use the arrow shows black. Is there a way to change this colour. I've altered various parts of the appearance which didn't work. thanks

Just realised what I was doing. I loaded into Sheet 1 rather than This Workbook. thanks again All bets on [2thumbsup]

Hi Skip, As I wasn't at work I couldn't try this on the spreadsheet I wanted to. I tried on a spreadsheet at home, couldn't get the date/time stamp to appear so I thought "try from scratch"(Book1) that's why I was querying range and Target address originally. thanks

Hi Skip, I think I'm missing something, as usual! Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Target.Address <> "$A$1" then Sh.[A1].Value = Now End Sub Should I be showing the range and change Target.Address to Book1 cheers

Hi Skip, The date & time to appear on each individual worksheet within the the spreadsheet when the individual worksheet has the information modified(added or removed) rather than viewed. e.g. A spreadsheet with five worksheets could show five different modified dates & times.Each date & time...

Hi, How do I show in a cell the last date and time a individual worksheet was updated ? thanks Seasons greetings