Posts by ashu1990
Re: multiplying a smaller array with consecutive sub arrays of a larger array
This is a kind of home work what you are asking for..
we can just let you to the path you have to walk the way on your own if possible you can hire a developer who can do this for you..
Re: Excel Macro to Add Border to Cells in Rows Based on Criteria in Column
Sub test() Dim linestyle As Variant, line As Variant Range("A1").Select Do While ActiveCell.Address <> Range("A65536").End(xlUp).Offset(1, 0).Address If ActiveCell.Value > 0 Then linestyle = Array(xlDiagonalDown, xlDiagonalUp, xlInsideVertical, xlInsideHorizontal) line = Array(xlEdgeLeft, xlEdgeTop, xlEdgeBottom, xlEdgeRight) For i = 0 To UBound(linestyle) Selection.Borders(linestyle(i)).linestyle = xlNone With Selection.Borders(line(i)) .linestyle = xlContinuous .ColorIndex = 0 .TintAndShade = 0 .Weight = xlMedium End With Next i Else End If ActiveCell.Offset(1, 0).Select Loop End Sub
if you got what you want please mark the thread as closed.