Thread: Help Please
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
RozB RozB is offline
external usenet poster
 
Posts: 1
Default Help Please

Why wont the activecell for each cell in the range refresh
The data from cell A11 changes as it moves down Row
How do I make the each cell request work

Rozit

Sub CheckMeReally(
For Each Cell In Sheets("Select").Range("selectLanguage_Area"
If Cell.Value = "yes" Then Cells(Cell.Row, 1).Cop
ActiveCell.Selec
ActiveSheet.Paste '""Cells(ActiveCell.Row + 1, 1).Select?
Next Cel
End Su