Calling another macro in same workbook

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

Quote:

---

Originally Posted by Rajesh Kr Joshi

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

---

It would probably help if we could see your FormatSheet macro (probably seeing the DeleteData macro would be helpful as well) and indicate where in the FormatSheet macro you think you want to run the DeleteData macro at. Posting a copy of your workbook with the macro installed in it would be even better.

I second Rick on that one. Keeps any assumptions out of the window, thus increasing the chances of a more accurate solution.

From what I gather, is this what you are looking for

Code:

---

If Worksheets("Sheet2").Range("J4").Value = 0 Then
Call DeleteData
End If

---

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

Quote:

---

Originally Posted by Excel Fox

From what I gather, is this what you are looking for

Code:

---

If Worksheets("Sheet2").Range("J4").Value = 0 Then
Call DeleteData
End If

---

---

The reason I hesitated in giving the OP an answer is I'm kind of sensing there is a loop iterating in FormatSheet and I wasn't sure if the If..Then you showed should be wrapped around the loop or embedded within it, hence my desire for more information.

Thanks Rick and Admin :)

This code helped.


Thanks
Rajesh