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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.