Consulting

Results 1 to 11 of 11

Thread: Column headers throws errors

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #9
    snb
    Guest
    or
    Private Sub Worksheet_Change(ByVal Target As Range)
        Application.EnableEvents = False
    
        If Target.Count = 1 * Target.Column < 3 * IsDate(Format(Target, ",00:00")) Then Target = Format(Target.Value, "00:00")
    
        Application.EnableEvents = True
    End Sub
    Last edited by snb; 08-06-2013 at 08:46 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •