Search results for query: *

#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...

Well, yeah, I'd like to use the list because my cells aren't really in order. It's more like: Sheet2 A1 101 A3 102 A5 103 Sheet3 A1 104 A2 105 A3 106 Sheet2 B1 should equal 107 I know, gotta make it confusing don't I!??!

Worksheet1 contains a list of numbers, 101-199, in cells a1 through a99. Worksheet2 looks like this: A1 101 A2 102 A3 103 Worksheet3 looks like this: A1 104 A2 105 A3 106 How can I make Worksheet2 look like this?: B1 107 B2 108 | B14 120 C1 109 C2 110 | C10 118 Basically, I want to...

If you're using Word as your editor, you have to open Word, go to Tools, Options, File Locations, and change the path for Documents. Of course, this changes the path for when you open Word and then try to open a doc.

Okay, I've tried and tried to figure this out, and I can't, so I'm coming to the experts. One of these days I hope to give back to this list as much as I've learned from it. I have a wrestling program set up. I have 6 kids wrestling. Each kid wrestles one of the other kids once. I have a...

That worked perfectly, thanks! Star for YOU!