Help with automating Application.GoTo fuction.

[RagingR12]

Hello! I usually come here for help when I can't find what I'm looking for, so maybe someone can help me.

I have a column with cell address:

$B$896

$F$994

$N$103

$V$961

$AH$509

$AX$222

$BB$1050

<tbody>
</tbody>

Now wat I want, is to go automatically trough the list, and place a * in the given cell address.
But I can’t make it work with Application.GoTo function in VBA

De addresse are in the same work sheet.

Thanks for any help.

 

[pgc01]

Same, without the loop

Sub Cell_Loop()

Range(Join(Application.Transpose(Range("GO2:GO4")), ",")).Value = "*"

End Sub

 

[RagingR12]

Thanks for all the help it works great.

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thanks for all the help it works great.