Please help me to show these range from sheet name "output" [Closed]

Report
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
i have a sheet name output in my worksheet.. i want i, j to show the path or range from "output" page. please help me to solve this issue.

Sub Max()
Dim i As Integer, j As Integer
i = 12
j = 1
Do Until i = 24
For j = 1 To 14
If Cells(i, j).Value = "0" Then
Cells(i, j).Select
With Selection.Borders(xlDiagonalDown)
.LineStyle = xlContinuous
.ColorIndex = xlAutomatic
.Weight = xlMedium
End With
With Selection.Borders(xlDiagonalUp)
.LineStyle = xlContinuous
.ColorIndex = xlAutomatic
.Weight = xlMedium
End With
End If
Next j
i = i + 1
Loop
End Sub

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!