can offer an explanation for this, that would
be great, however I am just happy it is working and that I know what I
should do to pass an array as a sub or function argument in future.
Cheers!
Anil
On Sunday, July 15, 2012 11:04:27 AM UTC+1, Anil Pandit wrote:
>
> Hi all,
>
> I hav
Hi all,
I have the following code in a sub routine which works (please see code in
bold font), but which I want in a separate routine, so I can re-use the
code.
--
Sub PowerReturnOutput()
' This sub procedure looks up the part number on she
56 AM UTC+1, Anil Pandit wrote:
>
> Hi all,
>
> I hope someone can help me, because I cannot see any reason why this isn't
> working.
>
> No action is taken for cell L39, however cells L40-L42 behave as expected.
>
> *Step 1: A value is changed in cell "L39&
', _
' "$L$43" To "$L$44"*
Call ValidationType
Case "$F$8" To "$F$9", _
"$I$8" To "$I$9", _
*"$L$39"* To "$L$42"
Call ValidationType
Call EnclosureAdd(Targ
t;L39" for some reason.
--Anil
On Tuesday, April 24, 2012 11:12:56 AM UTC+1, Anil Pandit wrote:
>
> Hi all,
>
> I hope someone can help me, because I cannot see any reason why this isn't
> working.
>
> No action is taken for cell L39, however cells L40-L42 behave as exp
Hi all,
I hope someone can help me, because I cannot see any reason why this isn't
working.
No action is taken for cell L39, however cells L40-L42 behave as expected.
*Step 1: A value is changed in cell "L39"*
Private Sub *Worksheet_Change*(ByVal Target As Range)
Application.EnableEvents = Fa
, Anil Pandit wrote:
>
>
> Thanks for the reply Don.
>
> I'm still getting the same Run-time error and then an Excel crash. The
> debug points to the line: "Columns.Hidden = False", stating: ""Run-time
> error message: Method 'Hidden' of object &
Range("E1:G1,J1:l1").EntireColumn.Hidden = True
>Case "AC42U"
> Columns("E:J").EntireColumn.Hidden = True
> Range("C5") = "AC"
> End Select
> Application.ScreenUpdating = True
> End Sub
>
> Don Guillett
> Mic
Hi,
I'm new to VBA and I'm posting this because I've been tearing my hair out
over this all day, so I hope someone has seen this before and can point me
in the right direction.
I have created a worksheet change event which hides some columns according
to a string that is chosen from a list in
