Hi I have two following macros in one wrokbook:

1- FormatSheet
2- DeleteData

I wants to trigger DeleteData macro while running FormatSheet macro when in Sheet2 J4 cell value is 0. So it woukd be somthing like this:

run DeleteData if Sheet 2 cell value =0 , if not continue with FormatSheet macro


Thanks
Rajesh