Loop through rows select the same cell

Hi guys,

I'm looking to loop through rows and select the same Cell each time - its doing my head in!

So far:

I have the LastRow count i.e.

Please Login or Register  to view this content.

works fine

I have what I want to feed the cell value into i.e.

Please Login or Register  to view this content.

So as an example:

- I want the code to select D1
- Call my code to test the value of D1
- Feed back value
- Then back to the beginning i.e. select D2, D3, D4 etc etc
- Until LastRow is hit

in the following layout I assume

Please Login or Register  to view this content.

any guide on the cell selection loop would be most helpful!

Thanks

Hi Scoobster_Doo

By now you should know about code tags!!!!

Please Login or Register  to view this content.

It appears to be looping the same cell over and over.

Is there any information in D1, D2, D3 etc

The code works:
Option Explicit

Please Login or Register  to view this content.

Glad you got it working...post your result please...thanks for rep points