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!

Recent content by JC10001

  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...
See more

Part and Inventory Search

Back
Top