| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
This code won't work, any ideas?
I'm pretty new with programming in excel. I'd like to know why the following
code does not insert the formula in the cell "P" & fila. Fila is a variable (number) that changes in a loop. Range("P" & fila).Formula = "=IF(H" & fila & "="",IF(G" & fila & "="","",G" & fila & "-E" & fila & "),H" & fila & "-E" & fila & ")" Thanks! Bregards Santiago |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
This code won't work, any ideas?
Range("P" & fila).formula = "=IF(H" & fila & "="""",IF(G" & fila & _
"="""","""",G" & fila & "-E" & fila & "),H" & fila & "-E" & fila & ")" -- Regards, Tom Ogilvy "Santiago" wrote in message ... I'm pretty new with programming in excel. I'd like to know why the following code does not insert the formula in the cell "P" & fila. Fila is a variable (number) that changes in a loop. Range("P" & fila).Formula = "=IF(H" & fila & "="",IF(G" & fila & "="","",G" & fila & "-E" & fila & "),H" & fila & "-E" & fila & ")" Thanks! Bregards Santiago |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
This code won't work, any ideas?
thanks, got it perfectly.
regards "Tom Ogilvy" wrote: Range("P" & fila).formula = "=IF(H" & fila & "="""",IF(G" & fila & _ "="""","""",G" & fila & "-E" & fila & "),H" & fila & "-E" & fila & ")" -- Regards, Tom Ogilvy "Santiago" wrote in message ... I'm pretty new with programming in excel. I'd like to know why the following code does not insert the formula in the cell "P" & fila. Fila is a variable (number) that changes in a loop. Range("P" & fila).Formula = "=IF(H" & fila & "="",IF(G" & fila & "="","",G" & fila & "-E" & fila & "),H" & fila & "-E" & fila & ")" Thanks! Bregards Santiago |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup won't work, any other ideas? | Excel Worksheet Functions | |||
| formula from Excel97 doesn't work in Excel2003,any ideas why? | Excel Worksheet Functions | |||
| RE Any ideas why this simple proc. won't work? | Excel Programming | |||
| Any ideas why this simple proc. won't work? | Excel Programming | |||
| Any ideas... Doesn't work... | Excel Programming | |||
![Santiago[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
