Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement in macro
Hi, I'm trying to get the formula below to run in my macro. This is a report I'll be running on a weekly basis and the number of blanks in column I will change every week. I'm trying to get the macro to apply the formula at the first blank but I'm having some issues. I've been kicking around the Dim LastRow as long but I keep getting various error messages. In a nutshell what I'm looking for is the macro to read the first blank in column I, then if AE = 7 or 11I want it to poplulate column I with FedEx Weeky Charge. =IF(AND(OR(AE2=7,AE2=11),I2=""), "FedEx Weekly Charge", "") Thanks for all your help. Eddie -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=553220 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement in macro
Bump. Thanks -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=553220 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement in macro
I'm not sure I understand...
But maybe... Option Explicit Sub testme() Dim NextRow As Long With ActiveSheet NextRow = .Cells(.Rows.Count, "I").End(xlUp).Row + 1 with .cells(NextRow, "I") .Formula _ = "=IF(AND(OR(AE2=7,AE2=11),I2=""""),""FedEx Weekly Charge"","""")" '.value = .value '???? End With End Sub punter wrote: Hi, I'm trying to get the formula below to run in my macro. This is a report I'll be running on a weekly basis and the number of blanks in column I will change every week. I'm trying to get the macro to apply the formula at the first blank but I'm having some issues. I've been kicking around the Dim LastRow as long but I keep getting various error messages. In a nutshell what I'm looking for is the macro to read the first blank in column I, then if AE = 7 or 11I want it to poplulate column I with FedEx Weeky Charge. =IF(AND(OR(AE2=7,AE2=11),I2=""), "FedEx Weekly Charge", "") Thanks for all your help. Eddie -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=553220 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement in macro
Thanks Dave. I found a work around but your way seems to be much cleaner and most likely quicker. I'm going to test it in a little bit. Thanks Eddie -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=553220 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I insert a macro into a boolean statement | Excel Worksheet Functions | |||
how to create automatic macro with if statement or similar | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
can i use an IF Statement to run a macro? | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) |