Results 1 to 6 of 6

is it possible to merge the to line in one

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    669

    is it possible to merge the to line in one

    Well, I have this piece of code
    Is it possible to to populate the ranges from the array in one go rather than tow
                   [ With Sheets(e)
                        x = 1
                        For Each myArea In .Columns(1).SpecialCells(2, 1).Areas
                            n = myArea.Count
    
    
                            myArea.Offset(, 1).Resize(n, 1).FormulaR1C1 = Application.IfError _
                                                                          (Application.Index(w, Evaluate("row(" & x & ":" & _
                                                                                                       x + n - 1 & ")"), Evaluate("column(" & [b1].Resize(, 1).Address & ")")), "")
                            myArea.Offset(, 3).Resize(n, 2).FormulaR1C1 = Application.IfError _
                                                                          (Application.Index(w, Evaluate("row(" & x & ":" & _
                                                                                                       x + n - 1 & ")"), Evaluate("column(" & [d1].Resize(, 2).Address & ")")), "")
    
    
                            x = x + 20
                        Next
    
                    End With

    Thank you in advance
    Last edited by mohadin; 06-20-2019 at 09:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Mail merge - capitalising last line of address
    By AlexnL12 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-22-2016, 09:06 AM
  2. How to merge four line graphs with each two drawn in different scales
    By Bhim Chaulagain in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2015, 03:59 PM
  3. Merge Row into One Cell with Line Break
    By Jetheat in forum Excel General
    Replies: 13
    Last Post: 03-11-2009, 07:27 AM
  4. add new line, merge two tables
    By mechant in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-12-2008, 09:23 AM
  5. mail merge document with a line graph
    By pmdavis_77 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-26-2005, 04:05 PM
  6. Merge and line break added.. How To?
    By amiart in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 04:06 PM
  7. Replies: 3
    Last Post: 04-11-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1