Recent content by LScharf

Thanks for confirming what I was seeing. The user will continue to copy her boss' contacts to her folder and then update his Contact Group (CG) with her contacts. The only downside, I believe, is the lack of a live link between his CG and her contacts. So he can't double click on a member of...

Thanks, noCalAdmin. She is an Owner of her boss' Contacts. She is not a Delegate. I've just been told by someone that it is not possible to use another user's contacts as an Address Book (which is what she needs to be able to do)...

Hi, a coworker upgraded to Outlook 2010 and wants to create a contact group in her boss' contact folder. She gets as far as creating the group but then she cannot add members from his contacts. Is this no longer possible in 2010? She used to do it in 2007. Thanks!

Hello, I have downloaded the binaries for a program that I'd like to install on a 32bit Windows Server 2008 R2. It includes an installer but that requires a 64bit OS. The instructions say that I can "sync to the source, build and deploy the binaries" myself. I've been searching the web for...

I have a workbook with two sheets and a range called 'guidance' on sheet2. I need to create a hyperlink on sheet1 to get the user to sheet2, based on a value lookup. So far I've got this: =HYPERLINK(CELL("address",INDEX(guidance,MATCH(C6,INDEX(guidance,,1),0),1)), "Go") The CELL function...

Perfecto! Thanks a million. You are a smooth... operator. Final code with necessary End Ifs: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Range("Clearer")) Is Nothing Then If Target.Value = "" Then...

Further guidance requested... I need to clear the contents of several columns, and they're not adjacent. This clearly doesn't work: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Range("Clearer")) Is Nothing Then...

The bourbon appears to have worn off... :o) Today the macro works. And for the benefit of others looking at this thread, I was able to use a named range: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Not Intersect(Target...

It's not working in that I delete the value from cell A19 (or A20, 21, etc.) and the adjacent cells (B19, C19) stay unchanged. FYI, I am using Excel 2010.

Although it actually doesn't work without the loop...

Beauty...

Thanks! That does the trick. I added to it to cover a range of cells: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub For Each i In Range("A19:A25") If Not Intersect(Target, i) Is Nothing Then If Target.Value = "" Then...

Hi, This should be pretty simple: I want to create a macro that deletes the contents of B19 and C19 as soon as the user deletes the contents of A19. I started with this but it doesn't work: Option Compare Text Sub clear_stuff() If Range("A19").Value = "" Then Range("B19:C19").ClearContents...

Using Backup Exec 9, a few weeks ago the time to back up the entire server went from 7.5 hours to 9 hours. I found that the extra 1.5 hours is entirely during the backup of the Exchange Mailboxes. However, the size of those mailboxes did not change. The only change to the server that...

Have you looked into using a cursor to loop through the rows and operate on each row one at a time?