Skip to main content
J
jonesn31-Visitor
1-Visitor
December 5, 2019
Solved

Range Variable in Excel

  • December 5, 2019
  • 1 reply
  • 4621 views

I'm trying to reproduce some of my Mathcad sheets in MS Excel format. One of the biggest hurdles is a finding a simple way to define a range (or column in the case of a spreadsheet) of dependent values that are defined by a start, interval, and end value similar to Mathcad's range variable. I'm guessing I'm going to need to implement VBA, but my skills with that are pretty minimal. 

 

Does anybody have suggestions or examples?

Best answer by JBlackhole

use the Fill / Series option ? or a simple macro (using the capability)

dstep = 0.1: dend = 1.0
ActiveCell.DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay, Step:=dstep, Stop:=dend, Trend:=False

 

 

 

1 reply

L
LucMeekes23-Emerald IV
23-Emerald IV
December 5, 2019

No programming required.

The range definition

x:=1,1.1...2

Translates to Excel as entering the first to items af the range definition in two subsequent cells and select them:

LucMeekes_0-1575540924216.png

Then you place your cursor this very tiny square:

LucMeekes_1-1575541002618.png

Press the left-mouse button and move downwards to cells below until the value in a cell reaches 2.

The result is:

LucMeekes_2-1575541130569.png

The same can be done for a row of cells...or for rows of cells

 

Success!
Luc

 

    ttokoro
    21-Topaz I
    ttokoro21-Topaz I
    21-Topaz I
    December 5, 2019

    Excel.png

    t.t.
    L
    LucMeekes23-Emerald IV
    23-Emerald IV
    December 5, 2019

    Nice,

    But it requires the list in column C. How did you get that?

    Otherwise formulated: I see you need a range to construct a range...

     

    Luc

    Terms & ConditionsAccessibility statement