Greetings,
This is my VBA for 1st sheet of my workbook,
It is in the Module 1
Public Sub MyMacro()
Sheets("a").Select
Tempcell = 0
For Each Bcell In Range("j14:j26")
If (Bcell = 0) Then
Range("j28") = Tempcell
End If
If Not (Bcell = 0) Then
Tempcell = Bcell
End If
Next Bcell
Sheets("a").Select
Tempcell = 0
For Each Bcell In Range("u14:u25")
If (Bcell = 0) Then
Range("u28") = Tempcell
End If
If Not (Bcell = 0) Then
Tempcell = Bcell
End If
Next Bcell
End Sub
Also I have
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Run "MyMacro"
End Sub
In worksheet (a) Selection change of Excel Object.
My question is how I can to "RUN" same VBA for other 7 sheets (b - h) of same workbook ?
Thanks for your help
Bookmarks