+ Reply to Thread
Results 1 to 9 of 9

Select dynamic range.

  1. 09-30-2011, 01:27 AM #1
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Select dynamic range.

    I am trying to select a dynamic range that resides in column "C" so I can populate a formula to the final row. Then I need to copy that same column down to the final row and special paste the actual values in column"B". Finally delete column "C".

    This is what I have so far with not much success. Any help would be appreciated.

    Please Login or Register  to view this content.
    Last edited by JapanDave; 09-30-2011 at 07:23 AM.
    Reply With QuoteRegister To Reply
  2. 09-30-2011, 02:06 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Select dynamic range.

    Maybe

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 09-30-2011, 02:08 AM #3
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Select dynamic range.

    Hey Roy. Yes Column C will have data in it. It is the column which will always have the last bit of data in the final row and that is why I am using it.
    Reply With QuoteRegister To Reply
  4. 09-30-2011, 02:10 AM #4
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Select dynamic range.

    Where are you pasting the formula?

    Also, what do you expect the formula to do?
    Last edited by royUK; 09-30-2011 at 02:12 AM.
    Reply With QuoteRegister To Reply
  5. 09-30-2011, 02:24 AM #5
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Select dynamic range.

    Hey Roy. If I am not mistaken the copy and paste into column B is missing. I tried the code and it is applying the formula to column C and then deleting column C.

    Thanks
    Reply With QuoteRegister To Reply
  6. 09-30-2011, 02:28 AM #6
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Select dynamic range.

    The formula works great, it takes any spaces out of words.
    Reply With QuoteRegister To Reply
  7. 09-30-2011, 02:37 AM #7
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Select dynamic range. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 09-30-2011, 02:57 AM #8
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Select dynamic range.

    Hey Roy, sorry to be such a pain, but this line is not doing its job. It is not pasting into column B.

    Please Login or Register  to view this content.
    I have added a sample workbook.
    Attached Files Attached Files
    Last edited by JapanDave; 09-30-2011 at 03:00 AM.
    Reply With QuoteRegister To Reply
  9. 09-30-2011, 03:12 AM #9
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Select dynamic range.

    Hey Roy,
    Figured it out.
    You may have made a typo.

    The last part nedded to be

    Please Login or Register  to view this content.
    Original code.
    Please Login or Register  to view this content.
    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)

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