I have this script that I would like to loop through the columns in the range and only copy the columns in which row 148 has a value of exactly 0![]()
Range("V1:AP19").Select Selection.Copy Workbooks("pc opp.xlsm").Sheets("Trading").Activate Selection.End(xlUp).Select ActiveCell.Offset(1, 0).Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=True
Bookmarks