Hi,

This is my first ever post on any forum ever so firstly I apologise if I don't follow the correct protocol! I have little knowledge of VBA but learning via experience (and youtube) rather than a course

I've got a Macro that copies a row and paste's the data to another workbook where it's stored, is it possible to prevent the macro from being run if any of the cells in row 3 are empty? (Row 3 - B3 to K3)

This is my macro to "Submit" the data:

Sub submit()
'
' submit Macro
'

'
Rows("3:3").Select
Selection.Copy
Workbooks.Open Filename:="N:\REPORTING\Liam\MTA Log.xlsm"
Rows("3:3").Select
Selection.Insert Shift:=xlDown
Range("B3").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
Application.CutCopyMode = False
Selection.ClearContents
Range("B3").Select
End Sub


Thank you in advance,
PS