| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert row
In COL A, how can I insert a row above cells whose contents begin with
0A? (That's a zero and an A) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert row
'========
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
