Hello,
I am very new to excel and need assistance in modifying a existing macro to also hide any rows within the same range with a value of 0.00 in column "C". Thanks in advance
Here is my current macro:
I am very new to excel and need assistance in modifying a existing macro to also hide any rows within the same range with a value of 0.00 in column "C". Thanks in advance
Here is my current macro:
Code:
'
' Sort Macro
'
'
ActiveWorkbook.Worksheets("sheet1").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("sheet1").Sort.SortFields.Add Key:=Range("G7:G30") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("sheet1").Sort
.SetRange Range("B7:I30")
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("A10").Select