Insert row on button position

[Q45]

How do I insert a row using a macro button that insert the row beneath the row that the macro button is touching?

[Anne Troy]

Curious....why not just put the Insert Row toolbar button up on the toolbar, or even on its own floating toolbar?

[Jack in the UK]

hi --
can i ask what your trying to do?

i love the question but can not work how this will be usable, the button will need to be moved about, can i suggest that the row is inserted below the active cell??? so that you select the row any column abd run the script so the row is inserted, thus no need for moving a button about all the time and that would be some complex script...

If thisis of in sure i can write some VBA code.

HTH
Rdgs
==========
Jack

[Q45]

It's a sales tracking tool to be used by very non-excel oriented people all over the country. They need to enter rows based on the number of sales and they need a tool to facilitate this under several different salespersons sections. (i.e., sales rep A consists of rows 4:8 initially, sales rep B consists of rows 10:14, etc... more rows need to be added to the specific rep that exceeds four sales a month.)

[Q45]

Any suggestions?

[RWinfield]

Maybe a stupid suggestion, but why not do a workbook with a seperate sheet for each salesman, then as long as they don't have more than 65,536 sales a month there shouldn't be any need to add a row.

Rick

[Q45]

This is a sold orders entry page that populates an individual reps own sheet.

Any ideas on how to do this?

[Q45]

Any suggestions?

[Ian Mac]

On 2002-02-21 05:33, Q45 wrote:
Any suggestions?

I'd suggest an Access Solution for this one

[Juan Pablo González]

Try this:

CommandButton1.BottomRightCell.Offset(1).EntireRow.Insert