| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro only run if cell is not empty
i have a macro thats copy a row to a worksheet. To make it perfect i want
that the macro looks if for example Cell A 5 in that row is not empty. If its not empty run de macro thats copy the row to a worksheet. If its not empty that the user got an error windows for example: A5 is empty Macro do not work. is this possible...? greetings. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only run if cell is not empty
try this Public Sub test() If Range("A5") < "" Then (macro name) Else MsgBox "A5 is empty Macro does not work." End If End Sub "Pieter" wrote in message ... i have a macro thats copy a row to a worksheet. To make it perfect i want that the macro looks if for example Cell A 5 in that row is not empty. If its not empty run de macro thats copy the row to a worksheet. If its not empty that the user got an error windows for example: A5 is empty Macro do not work. is this possible...? greetings. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only run if cell is not empty
If Range("A5") = Empty Then
MsgBox "Cell A5 is empty!" Else Call copymacro_name End If Regards, Stefi €˛Pieter€¯ ezt Ć*rta: i have a macro thats copy a row to a worksheet. To make it perfect i want that the macro looks if for example Cell A 5 in that row is not empty. If its not empty run de macro thats copy the row to a worksheet. If its not empty that the user got an error windows for example: A5 is empty Macro do not work. is this possible...? greetings. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only run if cell is not empty
thanks for the quick response but
this is only working when cell A5 is empty. it must also work when i want to run de macro on row 150 for example. so then A 150 the macro had to check if its empty or not. gr. "Stefi" wrote: If Range("A5") = Empty Then MsgBox "Cell A5 is empty!" Else Call copymacro_name End If Regards, Stefi €˛Pieter€¯ ezt Ć*rta: i have a macro thats copy a row to a worksheet. To make it perfect i want that the macro looks if for example Cell A 5 in that row is not empty. If its not empty run de macro thats copy the row to a worksheet. If its not empty that the user got an error windows for example: A5 is empty Macro do not work. is this possible...? greetings. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only run if cell is not empty
If Range("A" & ActiveCell.Row) = Empty Then
MsgBox "Cell A5 is empty!" Else Call copymacro_name End If Regards, Stefi €˛Pieter€¯ ezt Ć*rta: thanks for the quick response but this is only working when cell A5 is empty. it must also work when i want to run de macro on row 150 for example. so then A 150 the macro had to check if its empty or not. gr. "Stefi" wrote: If Range("A5") = Empty Then MsgBox "Cell A5 is empty!" Else Call copymacro_name End If Regards, Stefi €˛Pieter€¯ ezt Ć*rta: i have a macro thats copy a row to a worksheet. To make it perfect i want that the macro looks if for example Cell A 5 in that row is not empty. If its not empty run de macro thats copy the row to a worksheet. If its not empty that the user got an error windows for example: A5 is empty Macro do not work. is this possible...? greetings. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only run if cell is not empty
Perfect this is exactly what i want...
thanks "Stefi" wrote: If Range("A" & ActiveCell.Row) = Empty Then MsgBox "Cell A5 is empty!" Else Call copymacro_name End If Regards, Stefi €˛Pieter€¯ ezt Ć*rta: thanks for the quick response but this is only working when cell A5 is empty. it must also work when i want to run de macro on row 150 for example. so then A 150 the macro had to check if its empty or not. gr. "Stefi" wrote: If Range("A5") = Empty Then MsgBox "Cell A5 is empty!" Else Call copymacro_name End If Regards, Stefi €˛Pieter€¯ ezt Ć*rta: i have a macro thats copy a row to a worksheet. To make it perfect i want that the macro looks if for example Cell A 5 in that row is not empty. If its not empty run de macro thats copy the row to a worksheet. If its not empty that the user got an error windows for example: A5 is empty Macro do not work. is this possible...? greetings. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro only run if cell is not empty
You are welcome! Thanks for the feedback!
Regards, Stefi €˛Pieter€¯ ezt Ć*rta: Perfect this is exactly what i want... thanks "Stefi" wrote: If Range("A" & ActiveCell.Row) = Empty Then MsgBox "Cell A5 is empty!" Else Call copymacro_name End If Regards, Stefi €˛Pieter€¯ ezt Ć*rta: thanks for the quick response but this is only working when cell A5 is empty. it must also work when i want to run de macro on row 150 for example. so then A 150 the macro had to check if its empty or not. gr. "Stefi" wrote: If Range("A5") = Empty Then MsgBox "Cell A5 is empty!" Else Call copymacro_name End If Regards, Stefi €˛Pieter€¯ ezt Ć*rta: i have a macro thats copy a row to a worksheet. To make it perfect i want that the macro looks if for example Cell A 5 in that row is not empty. If its not empty run de macro thats copy the row to a worksheet. If its not empty that the user got an error windows for example: A5 is empty Macro do not work. is this possible...? greetings. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting a macro to see the next available empty cell | Excel Discussion (Misc queries) | |||
| Macro to populate next empty cell? | Excel Programming | |||
| Macro to run if cell empty | Excel Programming | |||
| macro to look for empty cell | Excel Discussion (Misc queries) | |||
| Need help with empty cell in Macro | Excel Programming | |||
Hybrid Mode
