Hey i am new here and fairly new to excel, I have a problem with my file and was wondering if anyone could help me with some code. I have 1 column (A) and in this column there is about 50K prices. What i am trying to achieve is to clear the contents of 4 cells at a time - So for example the first price is in A2 i need to clear the 4 cells below, then leave the price in A7 then move on to clear the next 4 cells and so on until it reaches the bottom of the column. So it clears 4 cells at a time and leaves one value. Thanks