+ Reply to Thread
Results 1 to 5 of 5

Select the last row in a column with data nd paste the value in the rest of the column

  1. #1
    Registered User
    Join Date
    01-09-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2010
    Posts
    3

    Select the last row in a column with data nd paste the value in the rest of the column

    Hi

    I would like to get VBA code to select the last row in column E that has data in it and paste the value into the next open cell down to row 32

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Select the last row in a column with data nd paste the value in the rest of the column

    Hi.

    Check this:

    TESTCOPY.xlsm
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    01-09-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Select the last row in a column with data nd paste the value in the rest of the column

    Thanks! Works great

  4. #4
    Registered User
    Join Date
    01-09-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Select the last row in a column with data nd paste the value in the rest of the column

    I apologise for posting a new query in the same thread, but i dont know where to go to post a new thread.

    I would like to create a macro that opens up my VPN client application and then insert my username and password automatically. Then it should automatically log onto a website and further enter a username and password and then possibly download some data.

    Im not sure if this is possible

  5. #5
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Select the last row in a column with data nd paste the value in the rest of the column

    Happy to help.

    Please click the star below...

+ 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