how I can use a sub procedure as an arguement similar
to what in done with OnTime .
I want to be able to name a sub procedure that itself may or may not have arguements as an optional arguement in other sub.
Private sub A ( arg, arg, arg, [optional subprocedure])
code
code
code
if statement
call optional sub
end if
code
code
End Sub
Then when sub A is called it executes the named optional sub , if one is named.
I am trying to get a statement to check 7 different cells to see if they contact the same value, i go into a little depth
if a person is late to work then, a text value of 'LT' for late is placed in the cell, if they are late the next day then another LT will be used and so on.
from this then how many mins they are late is loaded into the next cell so
i have so far (in english) =IF Cell Mon,Cell Tue,Cell Weds, Cell Thurs, Cell Fri, Cell Sat, Cell Sun = 'LT' then SUM all mins late
but excel is saying there are to many arguements, any one any ideas can provide sample spreadsheet if needed
I'm getting a type mismatch error on a .find method after i added the "After:=" arguement. without the arguement, no error. here is the code
View 10 Replies View Related