If ...Then Statement
Dave,
Using your structure...I managed to figure it out...
but is it correctly done?
Private Sub Worksheet_Change(ByVal Target As Range)
If Worksheets("Setup").Range("dailyupdate").Value = True Then SortThem
End Sub
Thanks
"Dave Peterson" wrote:
Maybe...
Private Sub Worksheet_Change(ByVal Target As Range)
If me.range("dailyupdate").value = True Then SortThem
End Sub
DailyUpdate is a named range (single cell) on the same sheet?
Scottie wrote:
Group,
I have a worksheet change evenet that I want to be able to toggle with a
named cell value.
Private Sub Worksheet_Change(ByVal Target As Range)
If dailyupdate = True Then SortThem
End Sub
NO errors, but it doesn't run.......I am totally lost as to how to fix
it.... I know there is something missing
If the value is false, I want it to just fail and stop.
Please help :)
Thanks in advance.....
Scottie
--
Dave Peterson
|