Results 1 to 17 of 17

Past a range of cells with a specified row width

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-07-2020
    Location
    New Zealand
    MS-Off Ver
    365
    Posts
    219

    Past a range of cells with a specified row width

    Hi,

    I have a code below that I did a macro recording on to copy a range of cells in a row directly below the copied row. I linked the code to a command button so that every time I click the command button it adds a new row. I cannot seem to extend on the code so that when copied, it copies it to a row height of 140. Also when copying, it narrows the Legend row cutting of some of the text. My code I'm using is

    Sub Add_New_CA()
    '
    ' Add_New_CA Macro
    '
    
    '
        Range("A130:T132").Select
        Selection.Copy
        Range("A130").Select
        Selection.End(xlDown).Select
        ActiveCell.Offset(1, 0).Range("A1").Select
        ActiveSheet.Paste
    
    End Sub]
    Last edited by AliGW; 04-10-2020 at 04:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Range Continuing Past Last Row
    By Oxygen Potassium in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-27-2019, 07:12 PM
  2. Cut and Past Range of Row to another sheet
    By TheTallOne in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-30-2018, 09:00 PM
  3. [SOLVED] SUMIF formula with dynamic column range and then expand the width of SUM range
    By gravythief in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2017, 08:36 AM
  4. Replies: 0
    Last Post: 07-24-2014, 09:11 AM
  5. [SOLVED] Cut & Past For Selected Range
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-26-2012, 11:03 AM
  6. Extending column width past 255 characters
    By shieldsty in forum Excel General
    Replies: 4
    Last Post: 09-26-2008, 07:56 AM
  7. [SOLVED] hOW DO i CHANGE COLUMN WIDTH FOR ONLY A SELECT RANGE OF CELLS?
    By RCONLON_291 in forum Excel General
    Replies: 2
    Last Post: 09-16-2005, 07:05 AM

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