Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling Blancks in Columns with the containing of cell.
Hi I would like to know how I can tell Exel to copy the cell above into the
actual cell if this is empty. If not empty, copy the value in the cell. ex. abcde abcde abcde fghij fghij fghij fghij hjjkl hjjkl and so on. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling Blancks in Columns with the containing of cell.
Enter this small macro:
Sub fill_in_the_blanks() Dim r As Range For Each r In Selection If IsEmpty(r.Value) Then r.Value = r.Offset(-1, 0).Value End If Next End Sub Then select the part of the column you want fixed. Then run the macro. -- Gary''s Student "Timo Hansen" wrote: Hi I would like to know how I can tell Exel to copy the cell above into the actual cell if this is empty. If not empty, copy the value in the cell. ex. abcde abcde abcde fghij fghij fghij fghij hjjkl hjjkl and so on. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use VB code IF to automate filling in 11 columns | Excel Discussion (Misc queries) | |||
Filling in empty cells in columns | Excel Discussion (Misc queries) | |||
filling information from one cell and filling another. | Excel Worksheet Functions | |||
Filling values to columns | Excel Programming | |||
Add new Worksheet after filling first 256 columns | Excel Programming |