Help does not help
 

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

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" wrote in message ...
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

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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

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

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

Cheers
JulieD

"JulieD" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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

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" 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" wrote ...
application means that it is Excel not VBA so look in Excel Help
not in VBA help.

"bandy2000" 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

"bandy2000" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

Have you tried Detect and Repair on the Help menu?


On Thu, 31 Mar 2005 17:41:02 -0800, bandy2000
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" wrote in message
...
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" wrote in message
...
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