![]() |
|
#1
|
|||
|
|||
|
I have the following codes
HTML Code:
Function PrjByMonth(strField As String, pMonth As Date)
Dim sht As Worksheet, i As Long, j As Integer
PrjByMonth = 0
For Each sht In ActiveWorkbook.Sheets
If Mid(sht.Name, 1, 2) = "FY" Then
For j = 3 To 14 'The row of dates. Starts at C1 to N1
If sht.Cells(1, j) = pMonth Then
For i = 2 To 30 'update with max row
If sht.Cells(i, 2) = strField Then
PrjByMonth = PrjByMonth + CDbl(sht.Cells(i, j))
GoTo nxtSht
End If
Next i
End If
Next j
End If
nxtSht: Next
End Function
Public Sub ViewPrjByMth()
Dim strField As String, pMonth As Date
Worksheets("PrjByMth").Visible = True
Sheets("PrjByMth").Activate
PrjByMonth strField, pMonth
End Sub
![]() ![]() |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable | shimulsiddiquee | Excel | 1 | 05-16-2017 07:39 AM |
| Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge | Berryblue | Mail Merge | 1 | 11-13-2014 05:36 PM |
Run-time error 91 object variable or with block variable not set
|
JUST ME | Word VBA | 4 | 03-25-2014 06:56 AM |
Run-time error '91': Object variable or With block variable not set
|
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
| 30+ days Variable Day Date Calculations via Fields | ztag | Word | 2 | 01-06-2012 11:12 AM |