Recent content by patme

#Value! It's like it's expecting an argument or something.

Formatted as General. It is in "VBA Project (Filename.xls)", module3. It was NOT in it's own module. I created a new module4 under this same project and still doesn't work. I don't know how to create a module that is NOT under the "VBA Project (filename.xls)" list. Also, is there something...

Skip, While this looks cool, I guess I don't know how to use a UDF. I've entered it in a cell as a formula ( =OneMore ), but nothing. I really need to learn VBA (the Very Basic Answers!) Thanks.

Thanks, I'll see if I can get this one to work.

Runtime error '5'. I knew you could come up with something Skip, now I just have to figure out what the error is. I tried removing all the Add-ins per another doc for this error, and no dice.

Is there a way to search ALL sheets in a workbook, w/o having to manually enter them into Skip's VB? Thanks.

Just ask them to create a global distribution list, named "Marketing Team", and ask them to hide the members. Also, ask them to give you admin privileges over that group so you can add/remove members as you need. Might also ask them to set it so only YOU can send email TO that group, if that's...

Started to try to walk you through it, but then found this great article: http://www.msexchange.org/tutorials/User-Groups-Distribution-List-Contact-Management.html If you have questions on this article, I can probably answer those. Pat

If you are running Exchange as your email server, there's a way. However, if not, then I'm guessing not. Not natively in Outlook anyway. Maybe your specific in-house email server has a way to add groups, and maybe your email admin can figure it out, but I don't see a way using a Personal DL.

Did you try adding the Group to the BCC field?

Okay. When I enter a new hyperlink, it assumes that I want the current sheet, which I do. When I hover my mouse over the link, the following appears: file:///c:/mypath/file.xls - 'sheet1'!ac66 Then, when I copy sheet1 to sheet2, and hover over the links in sheet2, they still read as shown...

No, already thought of that. OR, maybe but I'm not doing it correctly! I don't think you can.

I have a sheet, SHEET1, that I have some hyperlinks that jump from cell b10 to cell ac55. Once I have SHEET1 formatted the way I want, I want to copy it to SHEET2. The problem is, the hyperlinks are copied, but in SHEET2 they still point back to 'Sheet1'!AC55. Am I creating them wrong? I...

Okay, that worked, once I figured out the sheet syntax. Sorry, not a programmer, but I'm going to have to learn it after this project! Yeah, that works... 2 questions this week, 2 answers, BOTH by Skip! Thanks.

Found an answer, in part thanks to Anotherhiggins. =SUMPRODUCT(($Q$66:$Q$322=Rnd1M1W1)*($AE$66:$AE$322<>"")) Q66:Q322 is my range of kid names. Rnd1m1w1 is the name for a cell that I'm using to track kid1 AE66:AE322 is the range that I'm putting a "1" in if the kid wins. What I did figure out...