View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel_VBA_Newb Excel_VBA_Newb is offline
external usenet poster
 
Posts: 13
Default Advance in a cell range using VBA

How can I increment/decrement the address function of a cell range. Can I
move back and forward throughout a cell range?

Dim myCell As String
I.E myRange = Range (A1:A5)

For Each myCell in myRange.Cells
myCell.Adress++ (this is incorrect)
Next myCell

Thanks!