| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null statement
How do you set the commands that if the activecell is null
or blank, it carries out certain commands? This is the syntax I have right now, but the null command doesn't seem to be working correctlly. Please help, thank you. If ActiveCell Is Null Then Selection.AutoFill Destination:=Range(Cells("33", ActiveCell.Column - 1), Cells("33", ActiveCell.Column)), Type:=xlFillDefault Range("B30").End(xlToRight).Select ActiveCell.Offset(rowOffset:=6, columnOffset:=-1).Select Range(Cells("36", ActiveCell.Column - 1), Cells("40", ActiveCell.Column - 1)).Select Selection.AutoFill Destination:=(Range(Cells("36", ActiveCell.Column - 1), Cells("40", ActiveCell.Column)).Select), Type:=xlFillDefault End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| If statement that outputs specific text if cell is not null | Excel Discussion (Misc queries) | |||
| COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
| if a1 = null then a1 = b1...how do I do this? | Excel Discussion (Misc queries) | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
Threaded Mode
