Glad to help
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ChilExcel
Sent: Thursday, March 15, 2012 5:28 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sum hours weeks
Excellent !!! dguillett1 is what I need
Thank you very much for your
Excellent !!! dguillett1 is what I need
Thank you very much for your attention
Chilexcel
2012/3/15 dguillett1
> You may want to use this to total at the bottom of column E
>
> Option Explicit
> Private Sub CommandButton1_Click()
>
> Dim tr As Integer
> Dim b As Range
> Dim lr As Long
> tr
You may want to use this to total at the bottom of column E
Option Explicit
Private Sub CommandButton1_Click()
Dim tr As Integer
Dim b As Range
Dim lr As Long
tr = 2
For Each b In Columns(1).SpecialCells(xlCellTypeBlanks)
With Cells(b.Row - 1, "e")
.Value = Application.Sum(Range(Cells(tr, 2), Ce
See att.,
Option Explicit
Private Sub CommandButton1_Click()
Dim tr As Integer
Dim b As Range
tr = 2
For Each b In Columns(1).SpecialCells(xlCellTypeBlanks)
With Cells(b.Row - 1, "e")
.Value = Application.Sum(Range(Cells(tr, 2), Cells(b.Row - 1, 2)))
.NumberFormat = "[h]:mm"
End With
tr = b.Row +
