Active Cell in Excel Macros

Hey, I'm pretty new to using Excel macros. I'm writing a macro that will be activated from many different cells. It needs to reference some static cell locations regardless of where it is activated and some cell locations relative to where it is activated. To do this I need to "get back to my starting point" but I can't figure out how to determine (and store) the location of the active cell when the macro is first activated.

It seems like determining your current location should be quite simple but I'm stumped.

Thanks.