| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
"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 |
|
#8
|
|||
|
|||
|
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 |
|
#9
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
