| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: List of blank and non-blank cells
Hello,
I have a list that looks as follows: 1012 -blank- -blank- 1013 -blank- -blank- -blank- and so forth. What I like to do, is to get a VBA command that fills the blank cells with the above value until the next value is reached. In this example, first two blanks with "1012", the other blanks with "1013" until the end of the list is reached. The end of the list is reached, when there are no more values in the next column (lets say column B). Can anybody help? Thanks in advance! Mirja |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
| Nested IF - return a blank when compared cells are blank | New Users to Excel | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
![Mirja[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
