Hello
I want to make a vba function that writes the dates of " overtime days"
for more details find the attachment!
Best regards
Hello
I want to make a vba function that writes the dates of " overtime days"
for more details find the attachment!
Best regards
Up......up........up
Up....up....up
Up.....up.....up
here are 2 examples
Where are Excel experts???????
Well I tried and this is what I figured out so far it looks at the color it a start not sure how to adapt it to do what you need
![]()
Function CombineByColor(rData As Range, cellRefColor As Range) Dim indRefColor As Long Dim cellCurrent As Range Dim connect_it Application.Volatile indRefColor = cellRefColor.Cells(1, 1).Interior.Color For Each cellCurrent In rData If indRefColor = cellCurrent.Interior.Color Then connect_it = connect_it & cellCurrent & " + " End If Next cellCurrent CombineByColor = connect_it End Function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks