I have a situation where I have a list of employee names.
the Spreadsheet contains 7 columns and only one the (the last column) will contain a value. The columns can text and dates.
How could I set it up on the Selection change event that whenever the cell that contains the value (not the text or date cells) the workbook will save>
right now, I have this (which saves everytime a cell is "dirtied"):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Value > 0 Then ThisWorkbook.Save
I was trying to use the IsNumeric function but wasn't able to get it to work.
thanks for your help