+ Reply to Thread
Results 1 to 2 of 2

Move button to another sheet

Hybrid View

TRLWNC Move button to another sheet 10-20-2014, 11:31 AM
TRLWNC Re: Move button to another... 10-20-2014, 11:54 AM
  1. #1
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2016
    Posts
    99

    Move button to another sheet

    I posted a question here:
    (Sorry to ask in another's question. )

    And got an answer, and it works fine, but only for the page that I am on. I actually would like to move to another page. So, I have this code:

    Sheets("Raw Data").Select
        Range("A5").Select
    While this does move me where I want to go, it gives me an error (1004 "Select method of range class failed"). Is there something more to this that I am unaware of?

    Thanks
    Last edited by TRLWNC; 10-20-2014 at 11:36 AM. Reason: clarification

  2. #2
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2016
    Posts
    99

    Re: Move button to another sheet

    Found it. Dang, that's an easy solution.....

    http://support.microsoft.com/kb/291308

+ 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. [SOLVED] Button to move the focus of a sheet to cell A1
    By Consty1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2013, 07:36 AM
  2. Move specific columns from one sheet to another, without using button
    By flori_vucu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2012, 05:05 AM
  3. [SOLVED] Create a button to move to next sheet?
    By VACaver in forum Excel General
    Replies: 7
    Last Post: 07-29-2012, 09:03 AM
  4. VBA - button to move to another sheet to same cell
    By baz0912 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2008, 11:21 AM
  5. [SOLVED] Using a Button Object to move a sheet into a new Workbook
    By MK@Hartford in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2005, 11:55 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