Forum Discussion
Return the address of last cell by formulas
So I just learned that Ctrl + End will bring you to last used cell in excel (which is very useful, right?). Is there a way to refer to that cell in formulas? No VBA allowed. Or can I refer to la...
Thanks for help. However in this way, only one column can be processed in each formula. Is there a way to process entire sheet in a formula?
You could create a custom function in VBA, but you don't want to use that...