+ Reply to Thread
Results 1 to 3 of 3

Refer to a hidden sheet using a macro.

Hybrid View

  1. #1
    fullers
    Guest

    Refer to a hidden sheet using a macro.

    I have written a macro that will move data into a sheet that is hidden.
    However, when I run it I get the debugger message telling me it has failed.
    If I unhide the sheet and run it then it works fine.

    What is the best way round this?

    Thanks in advance.

  2. #2
    Tushar Mehta
    Guest

    Re: Refer to a hidden sheet using a macro.

    In article <79A44745-D43A-49FF-9606-EA803646B45D@microsoft.com>,
    fullers@discussions.microsoft.com says...
    > I have written a macro that will move data into a sheet that is hidden.
    > However, when I run it I get the debugger message telling me it has failed.
    > If I unhide the sheet and run it then it works fine.
    >
    > What is the best way round this?
    >
    > Thanks in advance.
    >

    What is the code that moves the data? My guess is you are activating or
    selecting something on the hidden sheet.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Multi-disciplinary business expertise
    + Technology skills
    = Optimal solution to your business problem
    Recipient Microsoft MVP award 2000-2005

  3. #3
    Gary Keramidas
    Guest

    Re: Refer to a hidden sheet using a macro.

    just don't activate or try to select the hidden sheet

    this copies data from sheet1 to sheet2 when sheet2 is hidden.

    Range("A1").Copy Sheets("Sheet2").Range("D3")

    edit the existing code and just reference the hidden sheet when you do your
    copying.


    --


    Gary


    "fullers" <fullers@discussions.microsoft.com> wrote in message
    news:79A44745-D43A-49FF-9606-EA803646B45D@microsoft.com...
    >I have written a macro that will move data into a sheet that is hidden.
    > However, when I run it I get the debugger message telling me it has
    > failed.
    > If I unhide the sheet and run it then it works fine.
    >
    > What is the best way round this?
    >
    > Thanks in advance.




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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