Re: $$Excel-Macros$$ macro for detecting date in row

2012-08-14 Thread pawel lupinski
Paul,   It's great this what I wanted Thank you so so so so much   Pawel From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tuesday, August 14, 2012 12:22 PM Subject: Re: $$Excel-Macros$$ macro for detecting date in row Ahh... I see

Re: $$Excel-Macros$$ macro for detecting date in row

2012-08-14 Thread Paul Schreiner
Ahh... I see what you're trying to do. Your worksheet has formulas. on any given day, you want to "freeze" the previous values so that they will no longer update. You PROBABLY only need to freeze the current date,  because yesterday's data would have been "frozen" yesteday, and the day before that