View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 99
Default Insert 5 Row if a Certain Value in Column A Q

Hi,

MyValue = 10000
x = Application.Match(MyValue, Range("A:A"), 0)
Rows(x & ":" & x + 4).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

isabelle

Le 2016-11-24 Ã* 15:01, a écrit :
I want to insert 5 blank rows, above the first time 10000 appears in Column A