Thread: Insert 5 Row if a Certain Value in Column A Q
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Insert 5 Row if a Certain Value in Column A Q
Hi Isabelle, hi Sean,

Am Fri, 25 Nov 2016 01:10:38 -0500 schrieb isabelle:

Rows(x & ":" & x + 4).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

Rows(x).Resize(5).Insert


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote