(Solved) – VBA How to loop through columns

(solved)-–-vba-how-to-loop-through-columns

This code adds a spinner button in each row. How could I write it to add a spinner button in each column… Lets say I want to add a spinner button in A1, B1, C1… G1.

Dim i As Integer
For i = 1 To 7
    ActiveSheet.Spinners.Add(Range("A" & i).Left, Range("A" & i).Top, 69.5, 20).Select
Next

Leave a Reply

Your email address will not be published. Required fields are marked *