confine macro to found set

[doglover1956]

I want to confine a macro to loop through a found set, in this case the current day. I have a worksheet, and a find macro runs upon entry to the sheet, so that the worksheet shows the records from the current day. I then run a looping macro. But instead of working on the found set, it starts looping through the entire data set. What's up?

If I do it manually, going one at a time, it works. I try going to the first record, the current record, using the enter function, nothing seems to work.

Thanks.

 

[suesloan]

Not possible. If you have a found set and loop using Records Next, it is not possible for the macro to get to any records outside of the set.

Sue Sloan