+ Reply to Thread
Results 1 to 1 of 1

Divide by one particular cell value in FormulaArray

  1. #1
    Registered User
    Join Date
    03-04-2017
    Location
    norway
    MS-Off Ver
    2016
    Posts
    41

    Divide by one particular cell value in FormulaArray

    Hello! I have 2 questions to create the matrix as perfect as possible:

    1) How do I change the line
    Please Login or Register  to view this content.
    so the "60" is variable?. Actually the cell value is 61(variable) and I need to divide the cell value-1. I created size as variable:
    Please Login or Register  to view this content.
    and tried to use that with no success. The code works perfectly now, but "60" has to be variable. The value is in one particular cell which is counted(in macro) earlier
    Please Login or Register  to view this content.
    . Whole code:

    Please Login or Register  to view this content.
    2) How do I create a timer in a master macro? I got total 21 macros in one Master and I want to check the duration time for the whole master to finish.

    I appreciate any help. Attached the file. Module "Master" contains all macroes I use. Module Step1-Step4 is the modules I am using. "Great_matrix" macro is in module Step4 where the problem is. All other modules will be deleted when the "Master" is perfect and works properly with all different range of stocks.
    Attached Files Attached Files
    Last edited by olli.excel; 03-13-2017 at 05:44 PM.

+ 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. how to divide one cell into two?
    By zazzz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2016, 12:36 PM
  2. Divide a particular cell value based on 2 criteria and paste value in another cell in VBA
    By Ganeshgopinath in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2016, 01:53 PM
  3. [SOLVED] Using VBA to Set FormulaArray in cell
    By Oscar Martin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-09-2014, 10:48 AM
  4. [SOLVED] divide cell based on partial contents of alternate cell
    By LG1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-03-2013, 05:57 AM
  5. Replies: 5
    Last Post: 04-10-2009, 10:15 PM
  6. [SOLVED] Divide a cell by 2 and then add that together
    By countrygirl0712 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-24-2006, 02:25 PM
  7. [SOLVED] I need to know if there is a way to divide a cell
    By kdwwattn in forum Excel General
    Replies: 1
    Last Post: 01-03-2005, 08:06 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