How to write a macro? (excel 2010)

I'm amater in Excel, not profi, and don't know anything about programing.

In attachemnt is what I need.

COMPLETE EXAMPLE.

1st sheet is short example to understand how it works, with ONE LINE.

2nd sheet is complete example, where can be many lines. In example I put 64 lines (it could be 128, 256, 512, 1024, 2048...)

NOTE: Integers and Number of terms (N) in seria can be very huge (so AS LONG).

Thank You for help.

Have a nice day.

Welcome to the forum sasamaribor,

How will you pass the values to VBA, will they be in a specific range in a sheet?
Maybe the array will already be in VBA?

If i understand correctly then you could use the functions below for a worksheet range:

Please Login or Register  to view this content.

If the array is in VBA already then maybe the below will help:

Please Login or Register  to view this content.

With formula you can get the same result with:
First number:

Formula:

Please Login or Register  to view this content.

Second number:

Formula:

Please Login or Register  to view this content.

Hello,

Pair of two numbers (A1, B1) are always different. And each number is in its own cell.

First number always mean the beginning of a seria (written verticaly), and the second number always mean how many terms are in a seria.Stavek (1).xls

Task is oposite.

In BASIC:

We have 2 numbers. And the seria has to be result.

First number is the first term of seria, and the second number is the number of terms in seria.

We have to form a seria. Written verticaly.


Concrete Example in XLS.

Please Login or Register  to view this content.

Clear data from B6 down and then RUN as otherwise you will not see the update: I too have Excel 2010

Sorry i went the wrong way with the logic, here is another piece of code that gives the same result:

Please Login or Register  to view this content.

Can You please look at concrete short example.exe? (attached in posted forum)

Don't understand

Please Login or Register  to view this content.

Not sure what you mean...

Not attachment Stavek(1).xls.

I have attached also Example.xls. You do not see it?

My attempt at getting to where you want to be, at this stage it is a bit of a guess:

Left:

Please Login or Register  to view this content.

Right:

Please Login or Register  to view this content.