Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel macro

Excel macro

ResolvedVersion 2003

Fri 19 Mar 2010, 11:50 Delegate Bruce said...

Bruce has attended:
Excel Advanced course

Excel macro

I have a spreadsheet with formulae in some cells of each row, and data in all cells of each row. I want a macro to select all the formulae in the row where the cursor is, insert a new row below the cursor location, and copy the formulae, but not the data to the new row.
Is this feasible please?

Tue 23 Mar 2010, 12:20 Edited on Tue 23 Mar 2010, 12:21 Trainer Jacob said...

RE: Excel macro

Hello Bruce

After reviewing your post there are two courses of action to follow:

1) Consultative route, we work on your files to derive a solution then show you how to do it. We will prepare a scope of work with durations and costs which you decide on before any work starts.

2) Attend our 2 day Excel VBA Introduction course and pick up the skills necessary to complete the work yourself.

If you are interested in progressing this please do let us know

Regards

Jacob

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Excel macro

Excel macro

RE: Excel macro

Excel articles

Excel tip:

Generating Random Numbers