Covert Excel Formula to Workbook
Posted on 2011-03-11
Can someone show me how I would go about applying the following excel code to a workbook. At the moment it applies to a worksheet called 2 Bull Up 3 Bear Dwn 2 Bull Up, but I would like to be able to apply globally on all worksheets.
With Sheets("2 Bull Up 3 Bear Dwn 2 Bull Up")
.Range("B2", .Cells(.Rows.Count, "B").End(xlUp)).ClearContents