Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Scott02

    Macro begins but won't complete loop process

    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...
  2. Scott02

    Macro begins but won't complete loop process

    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...
  3. Scott02

    Macro begins but won't continue 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...
  4. Scott02

    Macro begins but won't continue loop

    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...
  5. Scott02

    Excel Macro or VBA-Copy All Sheets to Paste Values/Formats to new book

    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...
  6. Scott02

    Excel formula question

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

    Office Short Cut Menu Fades in slowly

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

    Office Short Cut Menu Fades in slowly

    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...
  9. Scott02

    Excel Graph Dual Axis question

    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
  10. Scott02

    Excel Graph Dual Axis question

    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%...
  11. Scott02

    How do I make buttons and references available to other users ?

    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...
  12. Scott02

    Remove "Out Of Office" from OOO reply?

    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...
  13. Scott02

    Remove "Out Of Office" from OOO reply?

    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...
  14. Scott02

    Trying to close Active Excel Window

    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
  15. Scott02

    Trying to close Active Excel Window

    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
  16. Scott02

    Trying to close Active Excel Window

    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...
  17. Scott02

    Using Macro and Custom Auto Filter together

    ...Macro ' Macro recorded 2/28/2008 by UserNameHere ' ' Range("F4").Select Selection.Copy Selection.AutoFilter Field:=6, Criteria1:="=*" & Range("F4").Value & "*", Operator:=xlAnd Application.CutCopyMode = False End Sub Sub UTEST() ' ' UTEST Macro ' Macro recorded 2/28/2008 by...
  18. Scott02

    Using Macro and Custom Auto Filter together

    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...
  19. Scott02

    Using Macro and Custom Auto Filter together

    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...
  20. Scott02

    Using Macro and Custom Auto Filter together

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

Part and Inventory Search

Back
Top