insert format after specific time in string.

J

J.W. Aldridge

Data in A:G.
String of times listed in column F (with header in F1).
Need to search string and insert black line (code below) separating
all times after 12:30:01 AM.

12:09:39 AM
12:10:34 AM
12:30:04 AM
12:31:17 AM


Rows("20:20").Select
Selection.Insert Shift:=xlDown
With Selection.Interior
.ColorIndex = 1
.Pattern = xlSolid
End With
Selection.RowHeight = 5.25
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find then highlight in yellow 6
macro adding rows 8
Find Specific Rows in Range and Create New Tab 18
Trying to Learn Code to Copy Charts 2
using a time format in a count function 1
range naming not working in VBA 2
Time Format 6
Suming Up Time over the course of days 1

Top