Search results for query: *

Zelgar and Skip, The name of the worksheet is 'lookup'. I now see what you mean regarding the sheet name. I didn't add it to each of the range references within the For I statement. Prior to getting these responses, I did go in and change it back to hard numbers and the macro works, but not...

Hi, Before I ask, I've got to acknowledge I know nothing about VBA except what I've picked up trying to understand what they do. I recently copied a working macro to a new file and tried to duplicate the process by editing certain lines. Now, the first half works, but the For i= piece to loop...

Guys, sorry for posting in the wrong forum. My mistake and I'll try the other one. Andy, the For i = Range(.... piece is something I changed from the original macro so I could control the start/stop points for running the macro. I may put it back to hard coded within the macro and see if it...

Hi, Before I ask, I've got to acknowledge I know nothing about VBA except what I've picked up trying to understand what they do. I recently copied a working macro to a new file and tried to duplicate the process by editing certain lines. Now, the first half works, but the For i= piece to loop...

I'm hoping someone has something that already works, or it's a simple thing to set up. I have a file with multiple tabs and a lot of sumif formulas that cause the pc to struggle. I need to send these reports (active sheets only) to other people, but want to send only values/formats. Is there...

Skip, thanks for that tip. I've never heard of that one, but love it already! Scott

Thanks so very much! This has been driving me crazy for a few months! Scott

Hey everyone. I'm fighting an annoying issue and am hoping to find an answer here. In all office programs, when I right click for the short cut menu, it fades in very slowly. I've been unable to find a setting to adjust for this, but feel sure there is one. One pc works great, the other is...

That worked to change it to a line, then I still had to format it and change the axis from primary to secondary. Worked like a charm. Thanks a bunch Skip! Scott

I'm working on a graph and trying to use the Line-Column on two axis style, but can't seem to get the data to hit the right locations on the graph. Here's a sample of the data: Admissions Friendly Cleanliness Speed January 100,000 75% 80% 85% February 101,000 76% 81% 86%...

I'm no expert, but I know when you create macros, there's an option to "store" them on the file in use or in a personal file called PERSONAL.XLS. This way the macro is always available for you to use, but does not travel with the file itself. Maybe you have the macros you created stored in a...

Yeah, well if you have a better or different approach it may be best to do it. I tried this using my own yahoo email account to my work account (Outlook). My yahoo account never got the reply. It may only work with Outlook. Or maybe it'll show up later. I never said it was tried, tested...

Your post got my curiosity up so I played with this a little. If you go to Out of Office Assistant and click on Add Rule, you can create a Template that will be sent back to the person based on certain criteria of the message you received from them. For example, in my test of this, if I got an...

Application.quit worked great. Thanks again everyone for the assistance. One of these days I'm going to get a book for VBA and learn it! Scott

We'll try it. My buddy said he'd tried a lot of thing, but neither of us are VBA savvy, and don't know all of the commands. Thank you all for your help. Scott

Greetings, Someone I work with has a macro problem and I'm trying to help out with it...hoping someone here can shed some light. He has a process set up in his Scheduler to open and Excel file every morning at 9:00 am. When it opens, the current macro triggers, adds a new worksheet, retrieves...

I truly don't mean to keep this going, but I wanted to answer your concerns. Honestly, I don't know enough about macros to know why you're saying it wouldn't work. So far it's working fine, regardless of what cell I select. Just as an FYI, I've copied out all of the macros so you can see what...

Once I got the macro to use the input cell for the filter, I re-worked the macros. When someone hits the button, it unprotects the sheet, filters the appropriate column for rows containing the input word, then protects the sheet again. I added another macro/button to unprotect, delete the...

Higgins, I just saw your response, after the one from ck1999 had worked. I guess since I was trying to fix the autofilter, I wasn't thinking of it as VBA and needing a different forum. Thanks for your sugggestion as well. If I run into any problems during testing with the first one, I'll try...

Thanks ck1999!!!! I copied in your Selection statement and it worked perfectly. I really appreciate your help with this. Scott