I have this code
My aim is to have cell s27 enter the date each time anything in those other cells change. Possible? Is that code correct?![]()
Please Login or Register to view this content.
I have this code
My aim is to have cell s27 enter the date each time anything in those other cells change. Possible? Is that code correct?![]()
Please Login or Register to view this content.
Last edited by messiah166; 05-12-2011 at 07:16 PM. Reason: Added Code Tags
Hello messiah166,
The code is correct. Did you experience a problem when using it?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
It doesnt appear to be working. Its not placing the date in the cell as far as I can tell.
Hello messiah166,
Have you changed any values in cells "A50:AQ50" ? The macro looks for changes in these cells only.
yeah. I did. I will upload the sheet when I get to work today.
Hello messiah166,
If you can, it would be helpful to see the workbook. Can you post a copy?
Yes here is the workbook
gah i figured the problem out. i thought i had all cells between a50 and aq50 selected, but it appears i only selected those cells specifically. i want the whole worksheet
....................
Last edited by messiah166; 05-12-2011 at 07:17 PM. Reason: Removed this post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks