Forum Discussion
Assistance with a function applying to multiple worksheets
Hello! I recently added a function that helps me track the last Cell I modified In my Timecard Worksheet: =CELL("address") It tells me the last column and row that I entered data into making...
StickyVES Yes, without providing a reference =CELL("address",A1), it will return the address of the active cell regardless. If you put in a reference the sheet name will be retained.
- So A1 (or whichever cell I need it for), should be helping keep track of the cell I edit in a single sheet? It just makes it continually reference whichever cell I enter in the function and won't track my other entries.
People appear to have the opposite issue than me it seems. They have trouble making functions work over multiple sheets. I can't get that code to stop referencing the other sheets. Even if I could get the last cell I modified change color or something, Then clear it when I enter something else.
