Search results for query: *

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?

I'm not sure this is realistic... but here's my ideal solution: When my Outlook 2003 users (on Exchange) start a new email message, I want them to have a way to select Categories to include as recipients, right in the email. It could be a button that pops open a custom form, or whatever. The...

AHA! NOW it is!! Wow, now it works like a charm. Thanks so much.

No... if I select 78 in my listbox, SelectedDRG_Index returns 78. So if SelectedDRG_Index contains the value that I want to AutoFilter on, can't I just use that in my VBA? Which is what I did, and it works, except for that pesky "AutoFilter method of Range class failed" error every time.

Sorry, I meant the DRG column contains values equal to integers between 15 and 359 (with plenty o' gaps). There are 20 distinct DRG values. Each DRG has multiple rows (hospitals), so the range goes from row 10 to row 616. When I click on a value in my listbox, SelectedDRG_Index shows that...

You said: 5. Your selected value is then =INDEX(DRG_List,SelectedDRG_Index,1) but this doesn't work; my DRG list contains 20 values from 15 to 359, so if SelectedDRG_Index equals 359, the formula doesn't find a value... It works when my macro is Range("A10:E616").AutoFilter Field:=1...