Results 1 to 36 of 36

After copying in Macro - come back to previous sheet

Threaded View

JK1234 After copying in Macro - come... 09-27-2008, 09:56 PM
mdbct There is no need to select... 09-27-2008, 10:23 PM
JK1234 Other sheets 09-28-2008, 09:46 AM
royUK Maybe something like this... 09-28-2008, 10:06 AM
MatrixMan If I understand correctly... 09-28-2008, 10:26 AM
JK1234 These shold work - what if... 09-28-2008, 11:09 AM
royUK You can get the required... 09-28-2008, 11:40 AM
JK1234 Thank You 09-28-2008, 12:11 PM
royUK I'm not sure why you are... 09-28-2008, 01:07 PM
JK1234 Macro 09-28-2008, 01:16 PM
royUK Also get rid of the merged... 09-28-2008, 01:12 PM
royUK Instead of multiple Ifs, use... 09-28-2008, 01:30 PM
JK1234 How about this 09-28-2008, 04:23 PM
MatrixMan Here's how your case should... 09-29-2008, 08:55 AM
royUK Not sure if this is what you... 09-29-2008, 10:05 AM
JK1234 More Help 09-29-2008, 09:56 AM
royUK I have simplified this, it... 09-30-2008, 04:39 AM
Phil_V Select Case Range("N5").Value... 09-29-2008, 12:33 PM
JK1234 I changed the macro to show... 09-29-2008, 12:44 PM
MatrixMan I think you may have missed... 09-29-2008, 12:51 PM
JK1234 Hmm 09-29-2008, 12:58 PM
MatrixMan ... Actually ... that's not... 09-29-2008, 01:07 PM
  1. #1
    Forum Contributor
    Join Date
    07-06-2008
    Location
    NC
    Posts
    149

    After copying in Macro - come back to previous sheet

    I want to copy info from one sheet to another, come back and copy info to another sheet. I want to do this from alot of sheets. My goal is to remember the first page as a variable so if I do this on other sheets it will remember the sheet to come back to without using the tab name.

    example of what I want
    HTML Code: 

    then copy again to another sheet...but I do not want to use the name because if the macro is on a different sheet than I need that sheet name which would be way too much to do

    HTML Code: 
    Last edited by JK1234; 09-27-2008 at 10:20 PM. Reason: Changing title -too vague

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to populate a cell and then execute another macro
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2008, 02:19 PM
  2. macro to create a macro?
    By jojotherider in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2008, 08:34 PM
  3. Macro for copy/insert into expanding table
    By Soslowgt in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-06-2008, 07:24 PM
  4. How to splitt texts into words? (collecting word and compounds)
    By wali in forum Excel Programming / VBA / Macros
    Replies: 53
    Last Post: 02-03-2008, 04:06 AM
  5. Conditional formatting macro (highlight macro)
    By c991257 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2007, 02:46 PM

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