ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   insert format after specific time in string. (https://www.excelbanter.com/excel-programming/430378-insert-format-after-specific-time-string.html)

J.W. Aldridge

insert format after specific time in string.
 
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


All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com