Help does not help

[bandy2000]

I was looking for help for the Excel VBA expression

application.large


But I can't find anything useful neither in the offline nor in the online
help.
Where is this?

Thanks

[David McRitchie]

application means that it is Excel not VBA so look in Excel Help
not in VBA help.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bandy2000" <bandy2000@discussions.microsoft.com> wrote in message news:AAC6748D-EBFD-49D5-966D-67B672BC7642@microsoft.com...
> I was looking for help for the Excel VBA expression
>
> application.large
>
>
> But I can't find anything useful neither in the offline nor in the online
> help.
> Where is this?
>
> Thanks

[JulieD]

Hi David

i couldn't find it in VBA help either (ver 2003) ... bandy2000 is there any
other code or info you have on this?

Cheers
julieD

"David McRitchie" <dmcritchie@msn.com> wrote in message
news:eF7Vq%23kNFHA.2604@TK2MSFTNGP10.phx.gbl...
> application means that it is Excel not VBA so look in Excel Help
> not in VBA help.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "bandy2000" <bandy2000@discussions.microsoft.com> wrote in message
> news:AAC6748D-EBFD-49D5-966D-67B672BC7642@microsoft.com...
>> I was looking for help for the Excel VBA expression
>>
>> application.large
>>
>>
>> But I can't find anything useful neither in the offline nor in the online
>> help.
>> Where is this?
>>
>> Thanks
>
>

[bandy2000]

That is the complete sub I try to get working in order to mark the 10 max and
10 min values in the worksheet which name was passed to the sub.


Sub MarkTheCells(rng As Range, worksheetname As String)
Dim rng1 As Range
Dim l As Double, s As Double
Dim cell As Range
Worksheets(worksheetname).Activate
rng.Interior.ColorIndex = xlNone
l = Application.Large(rng, 10)
s = Application.Small(rng, 10)
For Each cell In rng
If IsNumeric(cell) And _
Not IsEmpty(cell) And cell.Text <> "" Then
If cell.Value >= l Then
cell.Interior.ColorIndex = 3
ElseIf cell.Value <= s Then
cell.Interior.ColorIndex = 5
End If
End If
Next
End Sub

"JulieD" wrote:

> Hi David
>
> i couldn't find it in VBA help either (ver 2003) ... bandy2000 is there any
> other code or info you have on this?
>
> Cheers
> julieD
>
> "David McRitchie" <dmcritchie@msn.com> wrote in message
> news:eF7Vq%23kNFHA.2604@TK2MSFTNGP10.phx.gbl...
> > application means that it is Excel not VBA so look in Excel Help
> > not in VBA help.
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "bandy2000" <bandy2000@discussions.microsoft.com> wrote in message
> > news:AAC6748D-EBFD-49D5-966D-67B672BC7642@microsoft.com...
> >> I was looking for help for the Excel VBA expression
> >>
> >> application.large
> >>
> >>
> >> But I can't find anything useful neither in the offline nor in the online
> >> help.
> >> Where is this?
> >>
> >> Thanks
> >
> >
>
>
>

[JulieD]

following on from your post in microsoft.public.excel.programming

application.large should be
application.worksheet.function.large

Cheers
JulieD

"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:%23IOw%23KlNFHA.3928@TK2MSFTNGP09.phx.gbl...
> Hi David
>
> i couldn't find it in VBA help either (ver 2003) ... bandy2000 is there
> any other code or info you have on this?
>
> Cheers
> julieD
>
> "David McRitchie" <dmcritchie@msn.com> wrote in message
> news:eF7Vq%23kNFHA.2604@TK2MSFTNGP10.phx.gbl...
>> application means that it is Excel not VBA so look in Excel Help
>> not in VBA help.
>> ---
>> HTH,
>> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
>> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
>> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>>
>> "bandy2000" <bandy2000@discussions.microsoft.com> wrote in message
>> news:AAC6748D-EBFD-49D5-966D-67B672BC7642@microsoft.com...
>>> I was looking for help for the Excel VBA expression
>>>
>>> application.large
>>>
>>>
>>> But I can't find anything useful neither in the offline nor in the
>>> online
>>> help.
>>> Where is this?
>>>
>>> Thanks
>>
>>
>
>

[David McRitchie]

It is NOT in VBA Help because it is Excel,
look in Excel Help, and you would need operands for
the LARGE Worksheet Function
so I think it is being presented out of context.

You might check if there is a User Defined Function
with the name of LARGE under the function wizard.
---

"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote...
> i couldn't find it in VBA help either (ver 2003) ... bandy2000 is there any
> other code or info you have on this?
>
> "David McRitchie" <dmcritchie@msn.com> wrote ...
> > application means that it is Excel not VBA so look in Excel Help
> > not in VBA help.
> >
> > "bandy2000" <bandy2000@discussions.microsoft.com> wrote...
> >> I was looking for help for the Excel VBA expression
> >>
> >> application.large
> >>
> >> But I can't find anything useful neither in the offline nor in the online
> >> help.
> >> Where is this?
> >>
> >> Thanks
> >
> >
>
>

[Bill Sharpe]

"bandy2000" <bandy2000@discussions.microsoft.com> wrote in message
news:AAC6748D-EBFD-49D5-966D-67B672BC7642@microsoft.com...
I was looking for help for the Excel VBA expression

application.large


But I can't find anything useful neither in the offline nor in the
online
help.
Where is this?

----
By any chance, do you mean
Application.WorksheetFunction.Large?

You can find this in VB help, starting with Table of Contents, expand
Events, Worksheet Functions, and Shapes, select Using Microsoft Excel
Worksheet Functions.

Bill

[bandy2000]

My Exel VBA Help is corrupted anyways. If I open it there are errors on the
page and no properties or methods are presented... All the links look
strange...
where can I get a working help file and how do I install it?
Thanks

"JulieD" wrote:

> Hi David
>
> i couldn't find it in VBA help either (ver 2003) ... bandy2000 is there any
> other code or info you have on this?
>
> Cheers
> julieD
>
> "David McRitchie" <dmcritchie@msn.com> wrote in message
> news:eF7Vq%23kNFHA.2604@TK2MSFTNGP10.phx.gbl...
> > application means that it is Excel not VBA so look in Excel Help
> > not in VBA help.
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "bandy2000" <bandy2000@discussions.microsoft.com> wrote in message
> > news:AAC6748D-EBFD-49D5-966D-67B672BC7642@microsoft.com...
> >> I was looking for help for the Excel VBA expression
> >>
> >> application.large
> >>
> >>
> >> But I can't find anything useful neither in the offline nor in the online
> >> help.
> >> Where is this?
> >>
> >> Thanks
> >
> >
>
>
>

[Myrna Larson]

Have you tried Detect and Repair on the Help menu?


On Thu, 31 Mar 2005 17:41:02 -0800, bandy2000
<bandy2000@discussions.microsoft.com> wrote:

>My Exel VBA Help is corrupted anyways. If I open it there are errors on the
>page and no properties or methods are presented... All the links look
>strange...
>where can I get a working help file and how do I install it?
>Thanks
>
>"JulieD" wrote:
>
>> Hi David
>>
>> i couldn't find it in VBA help either (ver 2003) ... bandy2000 is there any
>> other code or info you have on this?
>>
>> Cheers
>> julieD
>>
>> "David McRitchie" <dmcritchie@msn.com> wrote in message
>> news:eF7Vq%23kNFHA.2604@TK2MSFTNGP10.phx.gbl...
>> > application means that it is Excel not VBA so look in Excel Help
>> > not in VBA help.
>> > ---
>> > HTH,
>> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
>> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
>> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>> >
>> > "bandy2000" <bandy2000@discussions.microsoft.com> wrote in message
>> > news:AAC6748D-EBFD-49D5-966D-67B672BC7642@microsoft.com...
>> >> I was looking for help for the Excel VBA expression
>> >>
>> >> application.large
>> >>
>> >>
>> >> But I can't find anything useful neither in the offline nor in the
online
>> >> help.
>> >> Where is this?
>> >>
>> >> Thanks
>> >
>> >
>>
>>
>>