#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    2
    Rep Power
    0

    Select some columbs in every row


    Hi
    I write this in vba macros in excel but is wrong... What i do wrong ?

    Sub Colors_test()
    For counter = 3 To 110
    Range("("K" & counter), ("N" & counter), ("Q" & counter), ("T" & counter), ("W" & counter), ("Z" & counter)").Select

    Selection.FormatConditions.AddColorScale Bla Bla Bla+++

    Next counter
    End Sub
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    2
    Rep Power
    0
    Ok this work !!

    Range("K" & counter & ",N" & counter & ",Q" & counter & ",T" & counter & ",W" & counter & ",Z" & counter).Select
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    18
    Rep Power
    0
    I cant see quite what you are trying to do
    but this will probably do it more easily
    (by the way no need to select to change formats etc)

    range("K3:k110").font.colorindex = x
    range("N3:N110").font.colorindex = x


    etc

IMN logo majestic logo threadwatch logo seochat tools logo