Re: $$Excel-Macros$$ To count values in a changeble range

2013-06-28 Thread Thiago Souza
End If > > If cell.Value = "A" Then > hly = hly + 1 > End If > > > Next cell > End With > MsgBox "Work =" & wrk & " Holidays =" & hly & "

Re: $$Excel-Macros$$ To count values in a changeble range

2013-06-28 Thread Thiago Souza
help. Soon I'll need more help on a similar subject, I hope you can Help. Now I'll try to fit in my real sheets. Have a nice weakend 2013/6/28 VBA VABZ > Hi > > PFA.. > > Values will be updated in Status Bar.. > > > Cheers... > > > On Thu, Ju

$$Excel-Macros$$ To count values in a changeble range

2013-06-27 Thread Thiago Souza
I need some help with a code to the workbook uploaded. I'm having a hard time in finding a way to start! The workbook is to control day works of employes where they cannot work more than 183 days in the last 365 continuous days. I need a code where based on the selected cell it shows me anywher

$$Excel-Macros$$ validation

2013-06-13 Thread Thiago Souza
I need to validate an information like this __AB_C Name 1 w w Name 2 w w Name 3 oo Name 1 o w Name 2 w w so I need to do a conditional format showing (color or text box) the user that he can't use "w" again to "Name 1