Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    dinamic column.... (2000 sr 1)

    assuming i have this range and during the code the name of in range change a time is S a time T ecc... how to assign in range the column...
    I have understand to assign i a var the name of column but not clyar to insert in range

    Worksheets("GAF").Range("S" & R2)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: dinamic column.... (2000 sr 1)

    You can do it like this:

    Dim strColumn As String
    ...
    ' Assign value to strColumn, for example
    strColumn = "S"
    ...

    Worksheets("GAF").Range(strColumn & R2) = ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •