sjpistolesi
Programmer
In an earlier versions of Excel, up to xl97, used the following VBA instruction with no problems in a FOR EACH .... NEXT loop:
Columns("A"
.Find(MyProgID, after:=[A1]).Select
The Program ID (MyProgID) would change display of rows without incident.
Now, for some reason, this becomes a "locked" condition state and errors ["failed"] are generated when attempting to perform this function on a sequential Program ID.
Is there now, in version xl2000, an instruction that I need to use to toggle off the previous "Find" selection, before moving to the next "Find" selection?
Playing with the spreadsheet being used, I've needed to either "refresh" the data using "Data/Refresh Data" in order to release the previous "Find" .... otherwise the spreadsheet stays locked in the previous state, displaying the previous ProgID.
Frustrating ... Sandy Pistolesi
Columns("A"
.Find(MyProgID, after:=[A1]).SelectThe Program ID (MyProgID) would change display of rows without incident.
Now, for some reason, this becomes a "locked" condition state and errors ["failed"] are generated when attempting to perform this function on a sequential Program ID.
Is there now, in version xl2000, an instruction that I need to use to toggle off the previous "Find" selection, before moving to the next "Find" selection?
Playing with the spreadsheet being used, I've needed to either "refresh" the data using "Data/Refresh Data" in order to release the previous "Find" .... otherwise the spreadsheet stays locked in the previous state, displaying the previous ProgID.
Frustrating ... Sandy Pistolesi
