Need Macro to find cell and insert a row above it.

**Dnakr** · 01-23-2013, 01:14 PM

I am totally new to this stuff. I can usually find a macro and change it to fit what I need, but this time I am stuck.

What I am trying to do is create a macro that searches for a specific highlighted cell, then insert a row above it, and delete the highlighted cell. Hope that makes sense.

Thank you

Rachel

**OllieB** · 01-23-2013, 01:52 PM

Will the highlighted cell always in a particular column or can the cell occur anywhere on the worksheet?

**Dnakr** · 01-23-2013, 01:57 PM

It will always be in Column C

**OllieB** · 01-23-2013, 02:09 PM

Try (you will need to find the RGB values for the color green, select the cell click more colors and click custom to see the RGB values for the color green that you are using).

Please Login or Register  to view this content.

**Dnakr** · 01-23-2013, 02:40 PM

I can't get it to work. I used conditional formatting if that makes any difference on the Interior.color

Columns("C:C").Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlGreater, _
Formula1:="=0.208333333333333"
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 5296274
.TintAndShade = 0
End With
Selection.FormatConditions(1).StopIfTrue = False
End Sub

Thank you for all your help.

**OllieB** · 01-23-2013, 02:48 PM

I am on my iPad now so I cannot check whether conditional formatting makes a difference. Have you tried replacing the RGB() instruction with the value 5296274 yet?

**Dnakr** · 01-23-2013, 02:57 PM

Yes, if I put RGB(5296274) I get a compile error. If I remove RGB and leave (5296274) - nothing happens and if I leave only 5296274 nothing happens.

**OllieB** · 01-23-2013, 02:59 PM

Ok. Can we instead use the value that triggers the conditional format? For example find a cell with a timestamp > 16:00 and do.... Would that be n option?

**Dnakr** · 01-23-2013, 03:08 PM

Yes, anything greater than 5:00 would also work.

**OllieB** · 01-23-2013, 03:12 PM

Ok

Replace

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

I cannot test this right now, but I think this should work

**Dnakr** · 01-23-2013, 03:15 PM

OMG it worked. Thank you, thank you....

Rachel

**OllieB** · 01-23-2013, 03:17 PM

Glad to have been of assistance. Please remember to mark your thread as solved and to click on the star icon if you are happy with my contribution.

Need Macro to find cell and insert a row above it.

LinkBack

Thread Tools

Rate This Thread

Display

Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Re: Need Macro to find cell and insert a row above it.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions