View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Alpha Numerics bunch together

Hi,

When I type code the alpha numerics sometimes bunch together and the font
changes to red as in the case below. As in For i =1To2 and Nexti .

Sub CopyDemand()
Dim i As Integer
For i =1To2
Sheets("Demand").Select
ActiveCell.Offset(0, 2).Activate
ActiveCell.Copy
Sheets("Demand1").Activate
ActiveCell.Offset(0, 1).Activate
ActiveCell.PasteSpecial
Nexti
End Sub

Being a newbie at VBA programming I am sure there is a very simple
explanation for this.

Please will someone tell me what is happening.

Thank you.