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
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