Find Filled Cell

  • Thread starter Thread starter PrinceAli
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Mandatory cells only if another cell is filled 0
Excel VBA 1
Counting of cells with a specific color filled 9
How to auto fill cells in column 1
Series fill only copying and fill series greyed out 1
Formula to reference another cell in a worksheet 3
fill any random cell in a column and block all other cells 5

Back
Top