Excel & VB Question

[Joseph]

I'm developping a VB6 app that will write data to an Excel spreadsheet.
Does anyone know what code to write in VB that will force Excel to skip a
row in the spreadsheet? Thanks

 

[Frank Kabel]

Hi Joseph
there're several ways: You may have to explain your goal with a little
bit more detail

 

[Joseph]

First of all thanks for replying.
Essentially, I am writting a dataparsing routine in VB that will identify
records that fall within a 30 minute range and then force a line break or in
Excel an empty row. Example below illustrates first 4 records fall within
10:30:00 to 10:59:59 range and then a row is skipped, second batch of
records fall within 11:00:00 to 11:29:59. This is one of the things I am
trying to accomplish. Thanks!

Col A Col B

1HGCD5530TA040533 10:40:06
2GCEC19M0T1137750 10:42:06
4T1SV24E8MU455491 10:47:35
1FALP52U6SG227103 10:52:56

1g1jc1249t7260564 11:00:55
jh4da9455ms051785 11:12:43
1n4pb21s8hc809332 11:18:44

1gnct18z1k0108523 15:32:25
1g4bv81y6hx410507 15:45:05
2FMDA51UXWBB97713 15:46:54
4S3BK4259W7303877 15:51:19