| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find first non-empty cell ranght from column A
Hi There,
Could anyone help me with the following? If a cell in Column A form my Usedrange (supposing that Usedrange starts in Column A) is empty I would like to copy the first non-blank cell from that row into column A. E.g. A B C 1 Y Y Y 2 - - Z 3 - K - Should become: YYY Z-Z KK- Hope this makes sense, Sige |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find first empty cell in column | Excel Discussion (Misc queries) | |||
| Find first empty cell in column | Excel Discussion (Misc queries) | |||
| How to: Find first empty cell in column | Excel Worksheet Functions | |||
| Find a empty cell in next column | Excel Discussion (Misc queries) | |||
| How to find next empty cell within a column? | Excel Programming | |||
Threaded Mode
