+ Reply to Thread
Results 1 to 1 of 1

VBA - Getting row of macro button and copying data from that row

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    1

    VBA - Getting row of macro button and copying data from that row

    Test.jpg

    What I require

    • Identify the row the macro button is in, copy the 7 cells of data to the left of it in that row (data only ie not colour of cell etc) (from column B to column I)
    • Paste row into next available row in separate worksheet
    There are thousands of rows of data so I require a macro that all buttons are assigned to. I also need to know whether I will need Active X control or Form buttons.
    The end product is that everytime a button is clicked that row is copied and pasted into the next available row in a separate worksheet.

    What I have tried

    By visual basic experience is limited to say the least. I normally record macros and edit them where required and this particular coding is well above my level of expertise.

    I have searched the web and found that the following will be part of the coding for locating the row the button is in.*
    *ActiveSheet.Shapes(Application.Caller).Name*
    I have also found that the following will be part of the coding for pasting the information into the next available row.
    *
    Please Login or Register  to view this content.
    *
    Any suggestions for anything I could look into etc would be greatly appreciated.
    Many thanks.
    Last edited by arlu1201; 04-08-2013 at 08:59 AM. Reason: Use code tags in future.

+ Reply to Thread

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