+ Reply to Thread
Results 1 to 8 of 8

How to resize table range according to Column A last row

  1. 01-03-2017, 04:56 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Post How to resize table range according to Column A last row

    hi,
    i want to resize table1 according to column A

    if i have data now in A2:A500 and my table is till A2:A300 then it resize to A2:A500

    thanx
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 01-03-2017, 05:07 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: How to resize table range according to Column A last row

    May be
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 01-03-2017, 05:14 AM #3
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: How to resize table range according to Column A last row

    Or may be
    Please Login or Register  to view this content.
    Last edited by YasserKhalil; 01-03-2017 at 05:19 AM.
    Reply With QuoteRegister To Reply
  4. 01-03-2017, 05:53 AM #4
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: How to resize table range according to Column A last row

    thanx YasserKhalil for replying

    runtime error 9
    it says Subscript out of range

    edit
    its giving another eroor
    Attached Images Attached Images
    Last edited by HaroonSid; 01-03-2017 at 05:57 AM.
    Reply With QuoteRegister To Reply
  5. 01-03-2017, 05:58 AM #5
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: How to resize table range according to Column A last row

    above error is coming in below line

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 01-03-2017, 07:23 AM #6
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: How to resize table range according to Column A last row

    find out a solution
    giving code below for others
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-03-2017, 07:31 AM #7
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: How to resize table range according to Column A last row

    find out a solution
    giving code below for others
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 01-03-2017, 11:09 AM #8
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: How to resize table range according to Column A last row

    Simply the problem was with Table1, you would replace Table1 with Table2. That's all
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Resize table to my used range
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2016, 01:22 PM
  2. [SOLVED] Resize table to same row count as a piovt table
    By djon5020 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2014, 01:43 AM
  3. Resize range (table) in VBA based on last row value in another worksheet
    By Erin1986 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 01:36 AM
  4. [SOLVED] Get distinct values from Named Range, Table Column, or Pivot Table Row Label/Column Label?
    By e2Excel in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  5. [SOLVED] I have a range and a table. If the range equals the first column of the table sum second
    By g1eagle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2012, 06:50 AM
  6. Getting Range to move 1 column left and resize by 1
    By mozart in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2005, 04:05 AM
  7. [SOLVED] Range.Delete and Range.Resize.Name performance issues
    By Test.File in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2005, 12:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1