| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert formula to a range of cells from VBA?
How do i insert the following formula from range e2 to j26?
IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) ) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to insert formula to a range of cells from VBA?
Range("E2:E6").Formula = "=IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),""Not
Available"",IF(E2-TODAY()<0,""Expendite"",E2-TODAY()) )" but you will get a circular reference, as you have been told before. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... How do i insert the following formula from range e2 to j26? IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) ) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to insert formula to a range of cells from VBA?
What is a circular reference?
"Bob Phillips" wrote in message ... Range("E2:E6").Formula = "=IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),""Not Available"",IF(E2-TODAY()<0,""Expendite"",E2-TODAY()) )" but you will get a circular reference, as you have been told before. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... How do i insert the following formula from range e2 to j26? IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) ) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to insert formula to a range of cells from VBA?
It means that the cell formula is referring to itself. Look up 'Formulas
that refer back to their own cells' in the Answer Wizard in help. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... What is a circular reference? "Bob Phillips" wrote in message ... Range("E2:E6").Formula = "=IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),""Not Available"",IF(E2-TODAY()<0,""Expendite"",E2-TODAY()) )" but you will get a circular reference, as you have been told before. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... How do i insert the following formula from range e2 to j26? IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) ) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to insert formula to a range of cells from VBA?
What abt to a cell only? I seem to get error with the true or false value
enclose in bracket! "Bob Phillips" wrote in message ... It means that the cell formula is referring to itself. Look up 'Formulas that refer back to their own cells' in the Answer Wizard in help. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... What is a circular reference? "Bob Phillips" wrote in message ... Range("E2:E6").Formula = "=IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),""Not Available"",IF(E2-TODAY()<0,""Expendite"",E2-TODAY()) )" but you will get a circular reference, as you have been told before. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... How do i insert the following formula from range e2 to j26? IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) ) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to insert formula to a range of cells from VBA?
Ugh? Do you want to explain that?
-- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... What abt to a cell only? I seem to get error with the true or false value enclose in bracket! "Bob Phillips" wrote in message ... It means that the cell formula is referring to itself. Look up 'Formulas that refer back to their own cells' in the Answer Wizard in help. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... What is a circular reference? "Bob Phillips" wrote in message ... Range("E2:E6").Formula = "=IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),""Not Available"",IF(E2-TODAY()<0,""Expendite"",E2-TODAY()) )" but you will get a circular reference, as you have been told before. -- HTH RP (remove nothere from the email address if mailing direct) "crapit" wrote in message ... How do i insert the following formula from range e2 to j26? IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a column within a range of cells | Excel Worksheet Functions | |||
| Insert range of cells with a function | Excel Worksheet Functions | |||
| insert picture to a specfic range of cells | Excel Discussion (Misc queries) | |||
| Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement | Excel Programming | |||
| How can I insert a space before the last character in a range of cells | Excel Programming | |||
Hybrid Mode
