VBA: How to locate the last "CELL" of a specific "COLUMN"

Hello. I am new to VBA. My problem is quite basic. How do I locate the last used CELL or ROW in a "specific" COLUMN (not columns or sheet)? Most of the solutions focus on the general last rows.

I have a pre-designed worksheets with formulas below the empty entry cells. I would like to access the cells or rows consecutively in individual columns according to options in the heading. Example: If B2 has a data and I would like to input data on C2 the common algorithm does not allow me access but selects C3 for me. How to force Excel to let me squeeze the data without empty cell-spaces?

Thanks in advance.

Thanks for the prompt reply. But it does not compress the data neatly into the cells in the sheet. It leaves some empty spaces in some columns. If, B4 has data and C is empty, data input falls on C5 rather than C1 or C2 depending on the offset values.