Sep 30 2022 05:40 PM
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 it easier to track. The problem is, It works on all my worksheets in that workbook, which means if I enter something in my other worksheet: Data entry. The =CELL("address") cell in Timecard responds to that input in Timecard. Resulting in me losing my place. If there is some way for me to restrict a function to one worksheet I haven't been able to find it in my search. Hopefully I explained it well enough!
Open for alternative solutions as well. Thanks.
Sep 30 2022 10:37 PM
@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.
Oct 01 2022 11:26 AM
Oct 01 2022 12:23 PM
Oct 01 2022 12:52 PM
What you want is not possible using the CELL function:
You might use VBA code to store the address of the last used cell on the Timecard sheet in a cell, but that has the undesirable side effect of disabling Undo on the Timecard sheet...
Oct 01 2022 01:04 PM
Oct 01 2022 01:23 PM
There may be another way, depending on how that Timecard worksheet is laid out, and whether or not the final cell is always in the same column. I have a couple of worksheets in which I find it convenient to know what the last row is.
I use a formula like this: =COUNTA($A$7:$A$10000)
I know column A has some text in it in every row until the last one, so the count gives me the row number. (For now, the fact that it's limited to 10,000 max gives plenty of margin, but that number is arbitrary.)
It would be fairly easy to construct a cell reference, knowing that piece of information, if you always are using the same column for your last entry in Timecard