<div>
Kev,<br />
<br />
Thanks man......
</div>


<div>
Kev/Experts,<br />
<br />
Can someone please also convert the following globally across the workbook as Kevin did above?<br />
<br />
Sub Part1()<br />
&nbsp; &nbsp; Dim lastrow As Long<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; lastrow = Sheets(&quot;Stocks&quot;).Range(&quot;A&quot;<wbr /> &amp;&nbsp;Rows.Count).End(xlUp).Row<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Sheets(&quot;Stocks&quot;).Range(&quot;A1<wbr />:A&quot; &amp;&nbsp;lastrow).Copy _<br />
&nbsp; &nbsp; Sheets(&quot;Four Lows Five High&quot;).Range(&quot;B1&quot;)<br />
End Sub<br />
<br />
Cheers
</div>


Kev/Experts,

Can someone please also convert the following globally across the workbook as Kevin did above?

Sub Part1()
    Dim lastrow As Long
   
    lastrow = Sheets("Stocks").Range("A" & Rows.Count).End(xlUp).Row
   
    Sheets("Stocks").Range("A1:A" & lastrow).Copy _
    Sheets("Four Lows Five High").Range("B1")
End Sub

Cheers

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
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.<br />
<br />
Sub zolumn()<br />
&nbsp; &nbsp;With Sheets(&quot;2 Bull Up 3 Bear Dwn 2 Bull Up&quot;)<br />
&nbsp; &nbsp; &nbsp; .Range(&quot;B2&quot;, .Cells(.Rows.Count, &quot;B&quot;).End(xlUp)).ClearConte<wbr />nts<br />
&nbsp; &nbsp;End With<br />
End Sub<br />
<br />
Cheers
</div>
</div>


Hi Experts,

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.

Sub zolumn()
   With Sheets("2 Bull Up 3 Bear Dwn 2 Bull Up")
      .Range("B2", .Cells(.Rows.Count, "B").End(xlUp)).ClearContents
   End With
End Sub

Cheers

Covert Excel Formula to Workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.