Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: Replaceing an array

    Any way to remove the array like so

    I have cells B2:F2 with this forumla.

    {=TRANSPOSE('Data 1'!B66:B70)}


    I want a the cells to convert to this

    B2=B66
    C2=B67
    D2=B68
    E2=B69
    F2=B70


    I need a vba snippet to do this across a large range. I know I could edit each cell but there is 62500 cells.

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    Jay,

    One way would be to have a couple of nested loops. Such as,
    for i = 1 to 250
    for j = 1 to 250
    create the new formula using Range/Cells .Formula / .FormulaR1C1 = "new formula"
    next j
    next i

    For simplicity, if you post the range details someone might detail it if you need.

    regards,
    Fazza
    Last edited by Fazza; 10-10-06 at 05:03.

Posting Permissions

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