Silly Starter questions

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

It works, thanks alot!
The code is supposed to read a line of data, recognize where the data ends (cells are empty onwards), and then write a "Here" below the last cell that includes data in it.

Under worksheet, I do not see an "Open" event. I have Activate, BeforeDelete etc...

in vba editor click on this workbook and select 'workbook open'

Assemblage, welcome to the forum

For future reference, please use thread titles that are descriptive of your problem.

Also, please use code tags when posting code, it makes it easier to see/understand. See my notes on my signature on how to do that.

Thanks