+ Reply to Thread
Results 1 to 1 of 1

Trouble using button with macro to copy, paste & delete multiple selected cells

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Houston, TX
    MS-Off Ver
    MS Excel 2010 of MS Office 2010
    Posts
    1

    Trouble using button with macro to copy, paste & delete multiple selected cells

    I was able to create a macro and assign it to a button that would allow me to use the cursor to highlight a cell then click the button to have the values of that cell be copied, pasted into a different cell, then delete the value in the original cell. What I would like to be able to do is highlight multiple cells within the same column using the cursor, click the button, and have all highlighted cells be copied, pasted, and deleted. Here is the code that works for one cell.

    Please Login or Register  to view this content.
    Suggestions?
    Last edited by DGuidry; 02-09-2015 at 04:57 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:39 AM
  2. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  3. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  4. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  5. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM

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