Closed Thread
Results 1 to 2 of 2

Getting Worksheet_Change(Byval) to work with Worksheet_calculate on two different sheets?

  1. #1
    Registered User
    Join Date
    01-11-2020
    Location
    Norway
    MS-Off Ver
    Microsoft Office 2019
    Posts
    23

    Getting Worksheet_Change(Byval) to work with Worksheet_calculate on two different sheets?

    Hi,

    I have a sheet that needs to utilize the following code:

    Please Login or Register  to view this content.
    Then I have another sheet that is utilizing a code to transport values which is:

    Please Login or Register  to view this content.
    So, I can't transport values to the sheet that has the first code I wrote. I only get an error stating the following:

    Run time error 9
    Subscript out of range

    The code that transfer values work perfectly on other sheets that does not utilize the calculation code.

    Anyone know the solution to the problem?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,920

    Re: Getting Worksheet_Change(Byval) to work with Worksheet_calculate on two different shee

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue the original thread

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Worksheet_Change(ByVal Target As Range)
    By zubinnajmi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-24-2019, 08:50 AM
  2. [SOLVED] combine worksheet_change and worksheet_calculate
    By marcinnnn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2018, 08:40 AM
  3. HELP with Worksheet_Change(ByVal Target As Range)
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2018, 05:06 PM
  4. [SOLVED] Worksheet_Change (ByVal target As Range)
    By art_a_game in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2016, 11:21 PM
  5. [SOLVED] Worksheet_Calculate or Worksheet_Change or ... ?
    By miso.dca in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-31-2013, 06:13 PM
  6. Private Sub Worksheet_Change(ByVal Target As Range) Help
    By adamsj1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-28-2012, 09:17 AM
  7. [SOLVED] use of Worksheet_Change(ByVal Target As Range)
    By Isaac in forum Excel General
    Replies: 2
    Last Post: 07-07-2006, 02:10 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