Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
'========
Option Explicit Sub insertrowAboveOA() Dim i As Long For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1 If UCase(Left(Cells(i, 1), 2)) = "0A" Then Rows(i).Insert Next i End Sub On Feb 18, 1:36*pm, gwc wrote: In COL A, how can I insert a row above cells whose contents begin with 0A? *(That's a zero and an A) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
Insert cell/format/text/fontsize and auto insert into header? | Excel Programming |