Do you mean:

Sub InsetIt()
ActiveCell.EntireColumn.Insert
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"cravingmad" wrote in message
...
Ages ago I set up a function (ctrl + 2 I think) so I could easily add a
row
into an excel sheet without right clicking loads of times - unfortunatly I
need to do it again on another pc and can't remember how to do it - can
anyone help please - thank you.
Helen.