+ Reply to Thread
Results 1 to 3 of 3

Range(Selection, Selection.End(xlDown)).Select DO STUFF then **** Down

  1. #1
    Forum Contributor
    Join Date
    06-28-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    115

    Range(Selection, Selection.End(xlDown)).Select DO STUFF then **** Down

    First of all sorry for putting code in Title but tht is best title I thought of

    so here is my Macro, it is doing whatever I want it to do.

    Please Login or Register  to view this content.
    if I selected E6 and run that macro it would select everything from E6 to whatever cell contains last data lets say E400 so after it has cuted currently my macro goes back to E6 in cutmode I want it to still have data in CUT clipboard but end of marco it should have E7 highlited for me to paste cut cells in
    Thanks

  2. #2
    Forum Contributor
    Join Date
    06-28-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    115

    Re: Range(Selection, Selection.End(xlDown)).Select DO STUFF then **** Down

    nevermind I got it
    Thanks
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Range(Selection, Selection.End(xlDown)).Select DO STUFF then **** Down

    Yep, could shorten your code a bit like so also
    Please Login or Register  to view this content.
    Hope that helps.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1