Hi
If a cell in coulmn B changes value then a macro should be run.
As for now i have used workbook_change but that's not good because i need to change
other columns without running the macro.
How could i do that?
//Johan
Hi
If a cell in coulmn B changes value then a macro should be run.
As for now i have used workbook_change but that's not good because i need to change
other columns without running the macro.
How could i do that?
//Johan
![]()
Private sub worksheet_change(byval target as range) if not intersect(target,Range("B:B")) is nothing then 'code here end if end sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks