BeforeSave on a Colomn

[tcordo]

Hi All,

I am trying to setup a beforesave macro on a colomn value, but I can only management to make it work on a single cell.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

If ThisWorkbook.Sheets("Template").Range("A9").Value = "Invalid" Then
MsgBox "You need to fill up the invalid colomn"
Cancel = True

End If
End Sub

My aim here is that the range is not only A9, but all the colomn, but I cannot find my way.

Hope you guys can help out

All the best,
T

[Mumps1]

Try:

Please Login or Register  to view this content.

[tcordo]

Awesome Mumps you rock - I spent hours trying to figure that out ...

thanks again !

[Mumps1]

You are very welcome.