Thread: First Macro I want to create, can't run it . please help

First - please read the forum rules - all code must be wrapped in CODE tags.

I have NO idea how the Macro recorder generated the above code - it should be

sub macro2()
With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
        .PatternTintAndShade = 0
End With
End Sub

Try recording it again - Wend is part a loop control structure and there is an End If so there should be a starting IF (conditional statement) - so I have no idea why the recorder did this?? Did you copy and paste the recorded macro into another macro??
Hope this helps.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”

As per forum rules can you wrap your code in cod tags.

As for you problem , what exactly are you trying to achieve? If you could post a sample workbook to better describe what you are after, that would help a lot.