Assistance with a function applying to multiple worksheets

Question

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!&nbsp;Open for alternative solutions as well. Thanks.

stickyves · Answer

I have a nasty habit of finding problematic issues like this. Thanks very much for the help!

mathetes · Answer

StickyVES&nbsp;&nbsp;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: &nbsp;=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&nbsp;

dexterg_iii · Answer

StickyVES&nbsp;Yes, without providing a reference =CELL("address",A1), it will return the address of the active cell regardless.&nbsp; If you put in a reference the sheet name will be retained.&nbsp;&nbsp;&nbsp;

stickyves · Answer

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.

stickyves · Answer

Someone said I should just put the name of the worksheet "Timecard" But I don't know where in the function to place it. =CELL("address").

Forum Discussion

Assistance with a function applying to multiple worksheets

Share

Resources