What vba snipet can I use to select the next empty cell in column A (at the
bottom of my data) without referencing a specific cell?

For example I need to be able to go to the bottom of the data, but the
amount of data may vary so I need to be able to select the next empty cell in
a column without referencing a specific cell because the bottom of the data
won't be the same cell every time.

I've tried to just record a macro and press ctrl shift down or something
like that, but in the recorded macro it just references the cell at the
bottom of the data that the shortcut went to, not "the bottom of the data
that may vary based on what data I start with"

I apprecite all help!!!

Oh and I can't use addins because it will be a part of a much larger macro
so I'm hoping to have a code that doesn't have any manual work to it at all.

So much thanks!!!!