is there any function in excel (2003) for
if value more than 0 entered in cell say A1 should show today's date in
cell B1
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.faceb
IT WORKS ...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If WorksheetFunction.CountIf(Range("A3:G3"), "XYZ") > 0 Then
Rows("25:30").Hidden = False
End If
End Sub
THANKS FOR SHARING
On Saturday, 2 April 2016 11:21:18
lectionChange(ByVal Target As Range)
>
> Rows("12:18").Hidden =
> Worksheetfunction.countif(Range("A1:G2"),"ABC") > 0
>
>
>
> End Sub
> On Apr 2, 2016 19:18, "NIJ" > wrote:
>
>>
>>
>> On Saturday, 2 Ap
On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote:
>
> I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT
> POSSIBLE THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO FOR EACH
> CELL VALUE.
>
> Private Sub Worksheet_SelectionChange(ByV
On Saturday, 2 April 2016 06:30:27 UTC-7, NIJ wrote:
>
> I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT
> POSSIBLE THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO FOR EACH
> CELL VALUE.
>
> Private Sub Worksheet_SelectionChange(ByV
I want to aply below macro to cells A1 to G1 AND A2 TO G2. IS IT POSSIBLE
THAT IT CAN BE DONE SIMPLY INSTEAD WRITING BELOW MACRO FOR EACH CELL
VALUE.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1").Value = "ABC" Then
Rows("12:18").Hidden = True
