can u share a sample file?
On Sun, Mar 30, 2014 at 9:44 PM, Renata Torquato
wrote:
> Thanks.
>
> That's exactly what I tried before but it doesn't work ... =/
>
> Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu:
>>
>> Sub test()
>>
>> With Sheets("Sheet1")
>> If .R
Thanks.
That's exactly what I tried before but it doesn't work ... =/
Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu:
>
> Sub test()
>
> With Sheets("Sheet1")
> If .Range("a2").Value > VBA.Date And UCase(.Range("a1").Value) =
> UCase("ON TRACK ") Then
>
do u want to save the worksheets from active workbook only or from multiple
workbooks?
On Fri, Mar 28, 2014 at 2:22 PM, Ravinder wrote:
> Pls provide attachement
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Stefano Tagliaferri
> *Sent:* F
Sub test()
With Sheets("Sheet1")
If .Range("a2").Value > VBA.Date And UCase(.Range("a1").Value) =
UCase("ON TRACK ") Then
.Range("a1").Value = "DELAYED"
End If
End With
End Sub
On Sun, Mar 30, 2014 at 8:32 PM, Renata Torquato
wrote:
> I have the following s
I have the following situation:
I would like the range (A1) to change to the status DELAYED if this range
shows the status ON TRACK and if the deadline date on range A2 has passed
the current date (Formula TODAY in another sheet). If the condition is
false I would like range A1 to keep its stat
