MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Inserting a cell If....

Posted by Carl on March 21, 2001 6:57 PM

If the row value of column B equals 5 then I need to insert a single cell in that row in column E.
Have tried several VB scripts but haven't managed it yet. Thanks.

Posted by Celia on March 22, 2001 4:35 AM

I'm not sure I understand what you want to do but try this :-
Sub InsertCell()
If Selection = Range("B5") Then Range("E5").Insert Shift:=xlDown
End Sub