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 derfloh 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. Divercem

    Excel - Need Help to Shorten Formula

    Skip, Thank you for the responses. This code works very well, but it is a nightmare to maintain and if I can figure out tables like you suggested it will help when it comes time to change something. Answers to your responses: 1st response: I will look into the lookup tables and see if I can...
  2. Divercem

    Excel - Need Help to Shorten Formula

    ...Cell S33 - Accrue/Use CompTime = IF(C33="Sunday", ' If it's Sunday, there is no chance for comp time (Comp Time > 40 hours) 0, IF(AND(C33<>"Saturday",R33="U"), ' You can't USE CompTime on Saturday (but you can accrue CompTime) IF(ROW()-WEEKDAY(DATE($B$1,MONTH(1&$A33),B33))+7> ' If...
  3. Divercem

    Error 57121 on 2003 Excel after changing Tab name

    PH & Skip, I typically avoid using the Sheet Name and use what I now know is the Sheet CodeName so I started at the first textbox object in the UserForm and looked at the Properties Window and noticed that ControlSource is referencing 'WTS by Ext'!b1 (the name did change from 'Fueling by...
  4. Divercem

    Error 57121 on 2003 Excel after changing Tab name

    Thanks Skip When I change all code to Sheets("sBUxExt").expression I get run-time error '9': Subscript out of range. When I change all code to sheet1.expression I get run-time error '424': Object Required Since I don't know how to copy the Properties Window here's a text representation...
  5. Divercem

    Error 57121 on 2003 Excel after changing Tab name

    Thanks for the reply PH. I know my post was long, in the paragraph after "If I click end" is: If I click Debug it takes me to the ThisWorkbook Workbook_Open event at the line - Call sBUxExt.UserForm_Initialize; but it won't let me proceed until I stop and click design mode, then again I can...
  6. Divercem

    Error 57121 on 2003 Excel after changing Tab name

    I have a spreadsheet with a vbModeless UserForm that works for one business unit. When I open this spreadsheet and Save As to a different name I can close it and open it with no errors. But if I double-click on the first tab and change the tab name for another business unit then save the...
  7. Divercem

    Excel Command Button disappears when AutoFilter hides the row

    Out of curiosity. Is there a way to float the control objects as the page scrolls?
  8. Divercem

    Excel Command Button disappears when AutoFilter hides the row

    Beaver, Thanks for your reply. I don't know why setting the value to 3 didn't work, but I tried it again after your suggestion, but it wouldn't take. However, using Skip's suggestion, I selected all of the objects and followed his instructions and viola. Thanks to both of you for your...
  9. Divercem

    Excel Command Button disappears when AutoFilter hides the row

    I have an excel spreadsheet that has several command buttons to the right of the data which is in columns a:i. If I apply AutoFilter and select to hide data on the same row as the command button the command button gets hidden as well. I found through research that the Placement attribute 3 is...
  10. Divercem

    shell(cmd) works in debug, but not from cmdButton

    That did the trick. Sorry for the delay. We're changing domains, IP networks, email servers and telephones...this is the first chance I have had to try your suggestion. Thanks, Charlie
  11. Divercem

    shell(cmd) works in debug, but not from cmdButton

    I have the following vba code in an Excel spreadsheet with a cmdButton. When I click on the cmdButton I get an error that the file to be opened does not exist. When I step through in debug mode the file is created. I'm using the redirect output character ">" in the shell(cmd) which should...
  12. Divercem

    Excel 2003 - copy target cell's pattern color in Cond Formatting

    I was just trying to explain that I did search for threads on conditional formatting before I posted this thread. And I didn't find the thread Geoff listed because I was too restrictive with the keywords I chose - "excel 2003 conditional formatting". So, I guess I need to be more general on...
  13. Divercem

    Excel 2003 - copy target cell's pattern color in Cond Formatting

    Exellent examples Geoff, I kept searching for "excel 2003 conditional format" and didn't see the thread you listed. I'll try to be a little more diligent in my searches. Thanks for the info! Thanks Skip for your info, too!
  14. Divercem

    Excel 2003 - copy target cell's pattern color in Cond Formatting

    Skip, Thanks for the info on Format Painter. But I meant to ask if I could automate the process in conditional format 1 of cell C2 (for example). So that I could have 1 conditional format statement that would match the value of cell C2 (HOL) from an array (e.g. X1:X20) and apply the color of...
  15. Divercem

    Excel 2003 - copy target cell's pattern color in Cond Formatting

    I have a calendar for keeping track of employee time. I have several categories for not working on a weekday - Holiday, Plant Closed, Vacation, 1/2 day vacation, etc. Each of these categories need to be color coded, but conditional formatting only allows 3 conditions. Currently, I have the 3...
  16. Divercem

    .FoundFile Property for file size

    wow...that did the trick. Thanks strongm!
  17. Divercem

    .FoundFile Property for file size

    Thanks for your reply strongm. That worked until I came across a 3 GB file, the result went negative. Any ideas?
  18. Divercem

    .FoundFile Property for file size

    I am writing a VBA script in Excel 2003 to find all .pst files and their pathnames on the Network drives. I have the names, paths, but cannot find a property for the file size. I want to collect the file sizes so I can determine how to best fit them on a DVD for storage so I can get them off...
  19. Divercem

    Excel - Enter Sorted by information in Page Header

    That's what I thought. Thanks for replying.
  20. Divercem

    Excel - Enter Sorted by information in Page Header

    I have an Excel 2003 spreadsheet that has a dozen columns. Depending on the request the spreadsheet can be sorted logically by 4 columns. When you click on Data, then Sort, the column header selected last is still listed. I would like to create a Page Header containing the words "Sorted by...

Part and Inventory Search

Back
Top