Results 1 to 6 of 6

VBA for repeating a calculation and pasting a value-only list of inputs/outputs

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2019
    Location
    Glasgow, UK
    MS-Off Ver
    365
    Posts
    4

    VBA for repeating a calculation and pasting a value-only list of inputs/outputs

    So I have a single input cell (say D1) and a single output cell (say D2). I would like to make a table of pasted values for a range of inputs/outputs in the range A1:B100.
    I'm guessing this would be something using a For...Next loop (For i = 1 to 100) but I'm totally new to VBA and don't know how to write the macro.
    Any help would be very much appreciated. I hope I've explained the problem well enough!
    Last edited by HanJam; 05-24-2019 at 09:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cells that can be inputs or outputs
    By shawnamillion in forum Excel General
    Replies: 2
    Last Post: 02-11-2016, 11:58 PM
  2. [SOLVED] how to have multiple inputs and outputs?
    By Sticky_Frogg in forum Outlook Formatting & Functions
    Replies: 4
    Last Post: 07-22-2015, 12:51 PM
  3. [SOLVED] Getting different formula outputs for different given inputs
    By Jay Pee in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-12-2013, 04:19 AM
  4. IF with multiple inputs and outputs
    By zdej in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2013, 05:52 PM
  5. Help with multiple inputs and outputs
    By FinanceGuy in forum Excel General
    Replies: 1
    Last Post: 04-28-2010, 10:04 PM
  6. Calculation on Last Inputs into a List
    By AccountantCost in forum Excel General
    Replies: 3
    Last Post: 10-17-2009, 03:36 AM
  7. [SOLVED] Generate 1-to-1 outputs for a list of inputs into a excel formula
    By JBollinger1234 in forum Excel General
    Replies: 1
    Last Post: 05-11-2006, 08:10 AM

Tags for this Thread

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