| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Filled Cell
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find Filled Cell
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 -- Don Guillett Microsoft MVP Excel SalesAid Software "PrinceAli" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find percentage of filled cells in one section | Excel Discussion (Misc queries) | |||
| Find the number of the lowest filled row | Excel Worksheet Functions | |||
| Filled cells dont appear as filled | Excel Discussion (Misc queries) | |||
| Set cell to record date when adjacent cell is filled AND NOT RESET | Excel Worksheet Functions | |||
| How to find last filled in cell in a column? | Excel Worksheet Functions | |||
Linear Mode
