How to modify this code so the first cell is not included

[mrchonginhk]

Now this code apply to all cells in Col B

For Each cell In Sheets("Sheet1").Columns("B")

WHat if I want it start from B2, B3 etc ? ie B1 is not included
Thanks

 

[Trebor76]

Hi there,

The following will start from cell B5 (change the 5 to suit) to the end of column B:

For Each cell In Sheets("Sheet1").Range("B5", Range("B" & Rows.Count).End(xlUp))

HTH

Robert