+ Reply to Thread
Results 1 to 36 of 36

After copying in Macro - come back to previous sheet

Hybrid View

  1. #1
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I'm not sure why you are doing this, can you explain? There might be a simpler way to do it. You could use Named Ranges for example.

    I would start by using Data validation instead of the comboboxes
    Last edited by royUK; 09-28-2008 at 01:10 PM.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  2. #2
    Forum Contributor
    Join Date
    07-06-2008
    Location
    NC
    Posts
    149

    Macro

    I used the pull downs because there wasn't any room in the cells, the cells below them had different data and I had to resize the column widths and row heights. The pulldowns were an after thought so they fit better.

    My goal is to be able to copy from any sheet any section to any other sheet (many) and in any section. The good things are the sections are all the same amount of rows and columns.

    After playing with code the last several months, I am starting to understand "real" code more and appreciate that.

    I can actually write the code now with your guys help, but it would be alot of If pulldown 1 = ? and pulldown 2 = then. As you can see with 21 pages this could be alo ifs/then.

+ 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. 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