Results 1 to 6 of 6

copy find-paste

Threaded View

v|t0 copy find-paste 12-16-2008, 06:17 AM
royUK This is a bit crude but... 12-16-2008, 06:20 AM
v|t0 Thanks for prompt answer, but... 12-16-2008, 06:35 AM
royUK This will do what you want ... 12-16-2008, 06:47 AM
v|t0 Great, works like a charm! ... 12-16-2008, 07:41 AM
royUK If you are satisfied with the... 12-16-2008, 08:25 AM
  1. #1
    Registered User
    Join Date
    12-16-2008
    Location
    slo
    Posts
    3

    Question copy find-paste

    Hello,

    I would like to create macro, where it would on macro run copy text from active cell and find that value in another sheet (in column H) and select that cell.

    What I did is this:
        Selection.Copy
        Sheets("sheet2").Select
        Columns("H:H").Select
        Cells.Find(What:=Paste, LookAt:=xlPart, SearchOrder:=xlByColumns).Activate
    But this results in empty cell in the last non empty row in column A

    Thanks for help,
    Vito.
    Last edited by v|t0; 12-16-2008 at 09:27 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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