Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help!!!
Forgive me for the double post. I had posted this question earlier in
the general excel usegroup, then saw there was programming group and thought it belonged in here? I'm trying to create a macro that will execute the funcyion below on a three columns of data (C, E,F). The columns can vary in length from 26 to 60+ entries. How do go about doing this? =IF(E2=0,"? RT = "&TEXT(F2,"###.00"),C2) Any help is very much appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help!!!
Sub tester()
Dim vResult As Variant vResult = IIf(Range("E2") = 0, _ "? RT = " & Format(Range("F2"), "###.00"), _ Range("C2").Value) End Sub HTH -- AP a écrit dans le message de news: ... Forgive me for the double post. I had posted this question earlier in the general excel usegroup, then saw there was programming group and thought it belonged in here? I'm trying to create a macro that will execute the funcyion below on a three columns of data (C, E,F). The columns can vary in length from 26 to 60+ entries. How do go about doing this? =IF(E2=0,"? RT = "&TEXT(F2,"###.00"),C2) Any help is very much appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help!!!
sub tester
Var vResult as Variant vResult = Iif(Range("E2")=0, _ "? RT = " & format(F2,"###.00"), _ Range("C2").Value end sub a écrit dans le message de news: ... Forgive me for the double post. I had posted this question earlier in the general excel usegroup, then saw there was programming group and thought it belonged in here? I'm trying to create a macro that will execute the funcyion below on a three columns of data (C, E,F). The columns can vary in length from 26 to 60+ entries. How do go about doing this? =IF(E2=0,"? RT = "&TEXT(F2,"###.00"),C2) Any help is very much appreciated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help!!!
thanks, but I can't get to work. I saved the routine below and execute
tester as a macro and nothing happens? I'm sure I'm doing something wrong. any ideas?? Ardus Petus wrote: Sub tester() Dim vResult As Variant vResult = IIf(Range("E2") = 0, _ "? RT = " & Format(Range("F2"), "###.00"), _ Range("C2").Value) End Sub HTH -- AP a écrit dans le message de news: ... Forgive me for the double post. I had posted this question earlier in the general excel usegroup, then saw there was programming group and thought it belonged in here? I'm trying to create a macro that will execute the funcyion below on a three columns of data (C, E,F). The columns can vary in length from 26 to 60+ entries. How do go about doing this? =IF(E2=0,"? RT = "&TEXT(F2,"###.00"),C2) Any help is very much appreciated. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help!!!
I tried that and get a "Compile Error, Syntax Error"
Any way I could e-mail you my Spreadsheet? Ardus Petus wrote: sub tester Var vResult as Variant vResult = Iif(Range("E2")=0, _ "? RT = " & format(F2,"###.00"), _ Range("C2").Value end sub a écrit dans le message de news: ... Forgive me for the double post. I had posted this question earlier in the general excel usegroup, then saw there was programming group and thought it belonged in here? I'm trying to create a macro that will execute the funcyion below on a three columns of data (C, E,F). The columns can vary in length from 26 to 60+ entries. How do go about doing this? =IF(E2=0,"? RT = "&TEXT(F2,"###.00"),C2) Any help is very much appreciated. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help!!!
Yes please post it to
HTH -- AP a écrit dans le message de news: ... I tried that and get a "Compile Error, Syntax Error" Any way I could e-mail you my Spreadsheet? Ardus Petus wrote: sub tester Var vResult as Variant vResult = Iif(Range("E2")=0, _ "? RT = " & format(F2,"###.00"), _ Range("C2").Value end sub a écrit dans le message de news: ... Forgive me for the double post. I had posted this question earlier in the general excel usegroup, then saw there was programming group and thought it belonged in here? I'm trying to create a macro that will execute the funcyion below on a three columns of data (C, E,F). The columns can vary in length from 26 to 60+ entries. How do go about doing this? =IF(E2=0,"? RT = "&TEXT(F2,"###.00"),C2) Any help is very much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |