Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using win98 and xl2000. I am extracting data from websites.
The code runs once a minute. In the last 10 minutes, the following code appears to have taken "NasdaqPosColon" from the value in "NasdaqRng.Offset(0, 2).Value" on two occasions, and from the value in "NasdaqRng.Offset(0, 3).Value" on the other eight. Am I looking at corruption in the workbook or is there something intrinsically wrong with the code? '*****Code start******** Dim NasdaqRng As Range Dim NasdaqPosColon As Integer Set NasdaqRng = AIE01.[a65536].End(xlUp).Offset(1, 0) NasdaqPosColon = InStr(1, NasdaqRng.Offset(0, 2).Value, ":") If NasdaqPosColon < 0 Then 'More code... '*****Code finish******** Thank you Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
Reclaiming VBA Code in a corrupted file | Excel Programming | |||
Recover VBA code from corrupted .xls file? | Excel Programming | |||
Corrupted Code? | Excel Programming | |||
Get code from a corrupted workbook | Excel Programming |