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

    My first thought was, ...

    Common sense isn't all that common.... not my quote, but it sure is true Be Alert, America needs more lerts
  2. judgeh59

    Half a Movie is better than None

    6 o'clock High Be Alert, America needs more lerts
  3. judgeh59

    Vanity Plates "XVI"

    Pretend it's in your rearview mirror Be Alert, America needs more lerts
  4. judgeh59

    Punography

    [bigsmile] and the flatirons hanging from the earlobes... Be Alert, America needs more lerts
  5. judgeh59

    Punography

    Hudson and Landry.....I loved those guys.....the Weird Kingdom was great....thanks for the memories.... Be Alert, America needs more lerts
  6. judgeh59

    Punography

    I knew a lady named Penny Nichols Be Alert, America needs more lerts
  7. judgeh59

    VBA in Excel question

    you might have better luck posting this in the VBA Visual basic for applications (Microsoft) forum.... Ernest Be Alert, America needs more lerts
  8. judgeh59

    How to count records in one column, for each value in other column?

    It's a bit confusing on how you have your data set up...if it is set like this Col A Col b Jan North Jan North Feb North Mar South ... then a pivot table with Column labels being Date(col A) and row Labels being Region(Col b) and values being Count of Date(Col A) that...
  9. judgeh59

    MIcrosoft XP Pings Address not Specified

    I'm probably off base but is there a NAT Table somewhere that is mucking up the system? Ernest Be Alert, America needs more lerts
  10. judgeh59

    I'm looking for a formula to return text value if..... Similar to sumif formula but for text

    if Lionelhill is correct about how you have you data set up you can use VBA to loop through the rows and collect them in an array and then do whatever you want to with said array...if you go that route then it would make sense to repost this in the forum that Skip suggests... Ernest Be Alert...
  11. judgeh59

    Need 2 Excel Subtotals Using VBA

    if you truly want a VBA Solution then there a VBA group just for that.... VBA Visual Basic for Applications (Microsoft)... a repost into that group would be a good idea.... I'm also looking into a solution... Ernest Be Alert, America needs more lerts
  12. judgeh59

    Add leading zero to number in text string

    you're welcome Sir Ernest Be Alert, America needs more lerts
  13. judgeh59

    Add leading zero to number in text string

    this may not be easy but it seems to work on the data set you created and some corner cases I added... =CONCATENATE(LEFT(E3,1),TEXT(MID(E3,2,FIND("^",E3,1)-2),"00"),"^",TEXT(MID(E3,FIND("^",E3)+1,FIND("'",E3)-FIND("^",E3)-1),"00"),"'",RIGHT(E3,1)) this assumes your data is in column E and the...
  14. judgeh59

    Excel Error: Excel Found unreadable content

    Nope....excellent question though...I have talked with the IT folks here and they are going to upgrade the PC with one that has office 2007...everything I find about this says it's a bug in Excel...some people even have cases open with Microsoft and are still waiting for an answer...I should get...
  15. judgeh59

    Excel Error: Excel Found unreadable content

    Source file is created using the following: OS: XP PRO Sp3 - all updates completed Office 2003 - all updates completed Toad for DA is being launched by the windows scheduler and creating a file on the network. The file is being opened by (Managers Laptop): OS: Win7 - all updates completed...
  16. judgeh59

    Excel 2007 - Personal.XLSB Missing

    I have seen issues that during a push, network issues caused a corrupt install...I'm not sure the diagnostic/repair would catch it....just a thought...and doing a re-install doesn't take much time....but it might be better to do it local instead of a push... Be Alert, America needs more lerts
  17. judgeh59

    Excel 2007 - Personal.XLSB Missing

    so did the IT dept push this remotely on to your computer or did they come around with CD's?...I'm just wondering if a re-install might be the ticket....I'm remembering old Microsoft humor, like "MicroSoft has detected mouse movement, Please re-boot"...HTH Be Alert, America needs more lerts
  18. judgeh59

    Excel 2007 - Personal.XLSB Missing

    Hi Skip -- I'm in agreement with Zelgar...here is a thought though...is anyone else in the company having the same issue?...are you the only one who uses a PERSONAL.xlsb? Be Alert, America needs more lerts
  19. judgeh59

    Using the DOS start command

    I have never tried this in the Windows world, but in the old UNIX days I'd have run it background mode and that would close the window but keep the process running. Try putting an "&" at the end of the line...this may not help, but give it a shot... Be Alert, America needs more lerts
  20. judgeh59

    Hlookup with Variable.

    Hi Skip should there be a doublequote before the B$2 to match the one after the $3? Sheets("Sheet3").Range(B$2:S$3") ^ Ernest Be Alert, America needs more lerts

Part and Inventory Search

Back
Top