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!

  • Congratulations gkittelson 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. JC10001

    Chkdsk's hotfix not working

    When chkdsk is verifying my hard drive, I get an error message: File segment 7044 is unreadable and this goes on File segment 9602. Then, chkdsk tries to correct it, but I get another error message: Insufficient disk space to hotfix unreadable file 7044 and so on until 9602 (which btw, is...
  2. JC10001

    Have "ON ERROR" in a For-Next Loop, but still get errors when it's ok

    Thank you Jean-Paul! Worked like a charm!
  3. JC10001

    Have "ON ERROR" in a For-Next Loop, but still get errors when it's ok

    I wrote the following piece of code to check if all the names excluding Not Available in the Weights sheet (which are in a column starting from P6) have a match in the Report sheet. If it doesn't, it goes to the errorHandler like I intended. But, if there aren't any errors, it still gives me...
  4. JC10001

    Selecting numeric digits embedded in a cell in Excel

    sfvb and Dale Watson - you guys are great! Thank you so much! I really appreciate the help.
  5. JC10001

    Selecting numeric digits embedded in a cell in Excel

    I made a slight mistake in my above text. There is no $ sign in the cells. Anyway, I think somehow getting a macro to look for "Value: " and then store the numbers until the next "Total" would be a good start. If anyone has any suggestions, I would definitely appreciate it.
  6. JC10001

    Selecting numeric digits embedded in a cell in Excel

    For the life of me, I can't figure out a way to do this. But, for example, I have a bunch of cells that look like this: New Jersey Investment Total Value: $873,903,301.03Total Employees: 3801 New Hampshire Investment Total Value: $40,781,203.16Total Employees: 183 etc. So each state has its...

Part and Inventory Search

Back
Top