If(And()) Fuction (getting The "#NAME?)

Aug 20, 2009

I am getting the "#NAME?" in the sell containing the formula.

=IF(AND(B5="standard",B6="standard",B7="standard"),"standard",IF(AND(B5="Level 1",B6="Level 1",B7="Level 1"),"Level 1",IF(AND(B5="Level 2",B6="Level 2",B7="Level 2"),"Level 2",IF(AND(B5="Level 3",B6="Level 3",B7="Level 3"), "Level 3", IF(AND(B5="Level 4",B6="Level 4",B7="Level 4"),"Level 4", Custom)))))

Cell B5 contains "standard"
Cell B6 contains "Level 1"
Cell B7 contains "standard"
Cell B8 contains "standard"

View 2 Replies


OnTime Fuction

Aug 17, 2009

I am trying to get the following macro to run every half hour from 9am until 4pm.

I did try entering the following statement within the macro but I get the error message "compile error - arguement not optional"

TimeValue ("16:31:00"), "Mail_Selection_Range_Outlook_Body"

So here is my full macro. Thanks in advance for the help. (Using excel 2003)

Sub Mail_Selection_Range_Outlook_Body()

Dim rng As Range
Dim OutApp As Object
Dim OutMail As Object
Set rng = Nothing
On Error Resume Next
'Only the visible cells in the selection
Set rng = Sheets("Sheet1").Range("A1:C41").SpecialCells(xlCellTypeVisible)
'You can also use a range if you want
'Set rng = Sheets("YourSheet").Range("D4:D12").SpecialCells(xlCellTypeVisible)
On Error GoTo 0
If rng Is Nothing Then
MsgBox "The selection is not a range or the sheet is protected" & _
vbNewLine & "please correct and try again.", vbOKOnly
Exit Sub

View 9 Replies View Related

Fuction Combined With Sumproduct

Apr 2, 2009

I have a sumproduct function picking up data from a different worksheet. Because i have to much data it takes too much memory and it doesnt run that smoothly. Therefore i have hardcoded the function and tried to evaluate it using the EVAL() function from the morefunc add-in. However i don't get it to work. It continuously returns #VALUE.

This is the code i am trying to evaluate

SUMPRODUCT(--('Retrieve Depletions'!$A$4:$A$5000=$D4),--('Retrieve Depletions'!$B$4:$B$5000=$E4),--('Retrieve Depletions'!$C$4:$C$5000=$F4),--('Retrieve Depletions'!$D$4:$D$5000=$G4),--('Retrieve Depletions'!$E$4:$E$5000=$I4),--('Retrieve Depletions'!$F$4:$F$5000=$J4),'Retrieve Depletions'!H$4:H$5000)

View 9 Replies View Related

Count And Large In One Fuction

Jul 14, 2009

i'd like to get larget repeated number in one cell

not to make column for count and then take largest number, i need this in one cell only

View 9 Replies View Related

User Defined Fuction Is Being Called Several Times

May 4, 2007

When I use Excel's UI to create a function, the fn is being called several times. If I enter manually there is no problem.

Add this code in any module and goto menu, Insert, Function and then select
dosomething from the list and click OK. you will the msgbox is being displayed several times.

Public Function dosomething(aa As String, bb As String, cc As String, dd As String, ee As String, ff As String, gg As String, hh As String)
MsgBox "a"
End Function

View 9 Replies View Related

Left Fuction In VBA Code Getting Run Time Error 1004

Dec 25, 2009

I am trying to use the Left function in my VBA code but continue to receive run time error 1004 - Method 'range' of object '_global' failed. Not sure if the error originates for code being written incorrectly or if the left function is not available in VBA. I am basically trying to take the first 9-characters for each cell in column K and copy the values to column G.

View 3 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved