Help,

I need to loop thru some code. In so doing I need to
be able to increase the ("C14) cell reference each time I
loop.

sub Traffic()
Windows("Traffic.xls").Activate
Sheets("Sheet1").Select
Range("C14").Select
szCellValue = Worksheets(1).Range("c14").Value
MsgBox szCellValue
end sub

In the above example I have my VBA code reading the value
from Cell ("C14"). In the full Macro I will be using the
Value taken from this reference.


This loop will run for x times, where x is provided by a
user input (msgbox) the Cell reference will always start
at C14 and continue until cell is blank or cell c25 is
reached.

Can anyone help me with this???

Your assistance is appreciated.