View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
F[_2_] F[_2_] is offline
external usenet poster
 
Posts: 46
Default Delete rows depending on time value

Ah! Yes! Well spotted! Apologies, the times start in A9.

--
Frank


On 27/11/2018 16:56, Claus Busch wrote:
Hi,

Am Tue, 27 Nov 2018 15:22:31 +0000 schrieb F:

Thank you! That does exactly what I need to do (though it does complain
with a Run-time error '13': Type mismatch and Debug highlights 'If
Minute(.Cells(i, "A")) Mod 10 = 5 Then').


are there also other sheets in the workbook without the times in columns
A?


Regards
Claus B.