I have a current macro that selects data with certain criteria from a worksheet (test2) and it works great. But when I hide/very hide, it fails. Can someone please help me with what I need to do. Very hide is my preference. This is my current macro. Thank you!
Sub test()
Sheets("test2").Select
Range("A1").Select
Dim i As Range
Dim num As Integer
num = 1
For Each i In Range("a1:a160")
If i.Value > 0 Then
i.Select
ActiveCell.Rows("1:1").Range("b1:g1,i1:bf1").Select
Selection.Copy
Worksheets("test2").Select
and so on.
Bookmarks