Posted to microsoft.public.excel.programming
|
|
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
|