"FOR" loop to march through cells
Posted by Franklin on September 07, 2001 12:36 PM
Can anyone help me with the syntax for a simple for loop to march through a set of cells? For example, I want to go through a range of cells,activate and then speak them. Here is what I think the code might look like(with improper syntax...)
Private Sub CommandButton2_Click()
Dim i As Integer
For i = "b" To "z"
Please ignore the poor syntax as I am just picking up VBA. Thanks in advance for your help.