Prev: Macro for changing number of rows
Next: How to re-fresh the import links if it fails?
From: Rob on 1 Apr 2010 00:47
Hi,

When I type code the alpha numeric's 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.

From: OssieMac on 1 Apr 2010 01:14
Hi Rob,

Just insert some spaces between the words/numbers. VBA thinks it is one
string when the delimiter spaces are not included.

Example
For i = 1 To 2

With some code like endif VBA is smart enough to insert the spaces for you
and change it to End If but this does necessarily occur with all code.


--
Regards,

OssieMac


"Rob" wrote:

> Hi,
>
> When I type code the alpha numeric's 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.
>
 | 
Pages: 1
Prev: Macro for changing number of rows
Next: How to re-fresh the import links if it fails?