Find Filled Cell

P

PrinceAli

I have a selection columns A through D. I need some way in excel that
will identify which column has been filled since only one column per
row will be filled. Once I get the column that is filled I want to
look up a cell in that column for calculation purposes. For example if
column B is filled, I want to refer to the cell number (B163) of that
column.

Thank you for your help.
 
D

Don Guillett

This can be shortened but I leave as is so you see what is happening.
Sub findfilledcolumn()
mr = ActiveCell.Row
mc = Cells(mr, 1).End(xlToRight).Column
MsgBox mc
celltouse = Cells(163, mc)
MsgBox celltouse
End Sub
 
Top