| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace blank cells with NONE
Does anyone know how to cycle through a column or range and replace empty
cells with a value like 0 or NONE? The last row can vary each time... Here is the code I have so far: Dim strLstRw As String strLstRw = ActiveSheet.Range("A65536").End(xlUp).Row 'change empty cells to "NONE" Range("e11").Select Do If IsEmpty(ActiveCell) = True Then ActiveCell.Value = "NONE" ActiveCell.Offset(1, 0).Select End If Loop Until ActiveCell = "e" & strLstRw |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Replace blank cells | Excel Discussion (Misc queries) | |||
| Replace cells with blank | Excel Worksheet Functions | |||
| Replace cells with blank | Excel Worksheet Functions | |||
| Search and Replace Blank Cells | Excel Programming | |||
| How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
Threaded Mode
