Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109676
| From | isabelle <i@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Insert 5 Row if a Certain Value in Column A Q |
| Date | 2016-11-25 01:10 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <o18kku$slu$1@gioia.aioe.org> (permalink) |
| References | <85aeb851-dd87-4609-8e59-8370239ef907@googlegroups.com> |
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, seanryanie@yahoo.co.uk a écrit :
> I want to insert 5 blank rows, above the first time 10000 appears in Column A
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Insert 5 Row if a Certain Value in Column A Q seanryanie@yahoo.co.uk - 2016-11-24 12:01 -0800
Re: Insert 5 Row if a Certain Value in Column A Q Tvlebung396 <Tblebsng105@gmail.com> - 2016-11-25 01:03 +0000
Re: Insert 5 Row if a Certain Value in Column A Q isabelle <i@v.invalid> - 2016-11-25 01:10 -0500
Re: Insert 5 Row if a Certain Value in Column A Q Claus Busch <claus_busch@t-online.de> - 2016-11-25 07:29 +0100
Re: Insert 5 Row if a Certain Value in Column A Q seanryanie@yahoo.co.uk - 2016-11-25 12:23 -0800
Re: Insert 5 Row if a Certain Value in Column A Q aloinam109 <aloinam109@gmail.com> - 2016-11-26 17:03 +0000
Re: Insert 5 Row if a Certain Value in Column A Q PhunuSEO <PhunuSEO@gmail.com> - 2016-11-27 03:56 +0000
Re: Insert 5 Row if a Certain Value in Column A Q aloinam109 <aloinam109@gmail.com> - 2016-11-28 03:03 +0000
Re: Insert 5 Row if a Certain Value in Column A Q aloinam109 <aloinam109@gmail.com> - 2016-11-28 05:03 +0000
Re: Insert 5 Row if a Certain Value in Column A Q aloinam109 <aloinam109@gmail.com> - 2016-11-28 09:04 +0000
Re: Insert 5 Row if a Certain Value in Column A Q aloinam109 <aloinam109@gmail.com> - 2016-11-28 16:05 +0000
Re: Insert 5 Row if a Certain Value in Column A Q anhquan112016 <anhquan112016@gmail.com> - 2016-11-29 01:44 +0000
Re: Insert 5 Row if a Certain Value in Column A Q Tvlebung396 <Tblebsng105@gmail.com> - 2016-11-29 05:50 +0000
csiph-web