Cannot get macro to skip onto next macro after condition met

[Melbobs]

Hi

I am super new to VBA so please treat me as dumb.

I have a macro that has an IF statement in it. Basically it is referencing a cell, and ifthat cell is blank, I’d like it to go on to run the next macro. Previously the code said ‘End Sub’ but Irealised that was overriding the instruction to proceed with the next macro.

There must be a very simple answer to this but I have triedeverything. I even tried putting Elsestatements in.

Basically I need the code below to instruct (per the belowsheet and cell references):
Check to see if CA2 is blank
If so, then I want it to immediately go to Application.run “Fcopydown”
If CA2 is populated I want it to copy the value to C3001 inSheet1, then move down to the next block of code in the macro

Sheets("qryCC_PostOffice").Select
Range("CA2").Select
If Range("CA2") = "" Then Exit Sub
Selection.Copy
Sheets("Sheet1").Select
Range("C3001").Select
ActiveSheet.Paste

Please help as it's driving me mad

M

 

[Finalfight40]

Misread edit

 

[Joe4]

Welcome to the Board!

You say "move on to the next macro", which implies that you have multiple macros.
Can you post the VBA code for all your macros, and the procedure that is calling both of them?

 

[Melbobs]

Welcome to the Board!

You say "move on to the next macro", which implies that you have multiple macros.
Can you post the VBA code for all your macros, and the procedure that is calling both of them?

Hi. Thanks for thewelcome. Sorry I can’t paste them all itwould take up too much screen space.
They are just simple steps that basically need to say if X(in this case CA2) is NOT populated proceed to the next macro via theApplication.Run function, if X IS populated then it needs to proceed to thenext step within the current macro
Does that help?

 

[Joe4]

Typically, you would just have one "main" controlling macro that calls all the other macros like this:

Sub Main()
    Call Macro1
    Call Macro2
    Call Macro3
End Sub

If you do that, it will run Macro1, then when finished, it will proceed to Macro2, and when finished with that it will proceed to run Macro3.
You can add IF blocks around those macro calls if you only want to run some based on certain conditions.

 

[My Aswer Is This]

In your first post you said:

I am super new to VBA​

Maybe you would like to tell us what your ultimate goal is.

There is normally no reason to need numerous Macros to perform a task.
As being new to Vba you may think that is needed when it really is not

 

[Melbobs]

Typically, you would just have one "main" controlling macro that calls all the other macros like this:

Sub Main()
    Call Macro1
    Call Macro2
    Call Macro3
End Sub

If you do that, it will run Macro1, then when finished, it will proceed to Macro2, and when finished with that it will proceed to run Macro3.
You can add IF blocks around those macro calls if you only want to run some based on certain conditions.

Utter genius