Help does not help

B

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
 
D

David McRitchie

application means that it is Excel not VBA so look in Excel Help
not in VBA help.
 
J

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 said:
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 said:
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
Click to expand...
Click to expand...
 
B

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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
J

JulieD

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

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

Cheers
JulieD

JulieD said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
D

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.
---
 
B

Bill Sharpe

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
 
B

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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
M

Myrna Larson

Have you tried Detect and Repair on the Help menu?


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 said:
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 said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
Top