S
Shelby461
I would like to know how to write VB code that will insert an empty row
inside a loop. Example:
A B
1 RKG1567 10:40:06
2 TYP7892 10:42:06
3 OPR4567 10:47:35
4 FGB2436 10:52:56
5
6 YTR1234 11:00:55
7 GHU8543 11:12:43
8 BNF2467 11:18: 44
In the above example, there are two columns A & B. My program will loop
through and identify those records that fall within a 30 minute window.
Records 1,2,3 and 4 fall within 10:30:00 through 10:59:59 after which a
blank row is inserted. Any ideas on how to accomplish this? Thanks!
inside a loop. Example:
A B
1 RKG1567 10:40:06
2 TYP7892 10:42:06
3 OPR4567 10:47:35
4 FGB2436 10:52:56
5
6 YTR1234 11:00:55
7 GHU8543 11:12:43
8 BNF2467 11:18: 44
In the above example, there are two columns A & B. My program will loop
through and identify those records that fall within a 30 minute window.
Records 1,2,3 and 4 fall within 10:30:00 through 10:59:59 after which a
blank row is inserted. Any ideas on how to accomplish this? Thanks!