Hello Guys,
I have 3 questions:
1. I've written the following code but I keep getting "next without for" compile error:
Sub Main()
Dim i As Integer
For i = 1 To 11
If Cells(4, i).Value <> "" Then
Next i
Else
Exit For
End If
Cells(5, i - 1).Value = "Here"
End Sub
Any ideas where I was I wrong?
2. If I want something to run on start up, without clicking anything, I just put the function under sub main() ?
3. I have an image on the worksheet, and I would like to set its location on start up based on some conditions. How do I do it as I don't know the image's name/property... ?
Thanks a bunch,
Ron
Bookmarks