In the A1 reference style, absolute reference is designated with a $ sign.
So for absolute column and relative row it would be $A1. This would allow
the row to change relative to the location of a formula in another cell, but
the column would always be A. There is a good explanation of this in the VBA
help files. From Excel, press Alt + F11 to open the VB Editor, click on
help, then type "How to reference Cells and Ranges" Click on the same title
when it appears in the topic window.
It offers several different methods of relative references.

" wrote:

Yes, that is exactly what I needed. Thank you.

How about this: I have activated a row or a cell on a row and would
like to use a macro to select the very first cell (of column A) on the
next row. So a relative reference to a row but an absolute reference
to a column altogether. How would you do this?