MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MACROS - AND ADDING A NEW LINE.....


Posted by RICHARD on December 31, 2001 6:08 AM

HI - I'M HAVING TROUBLE RUNNING A MACRO THAT ALLOWS ME TO ADD A NEW LINE TO MY CUSTOMERS PAGE.

I WANT TO BE ABLE TO APPLY A MACRO TO A BUTTON ON MY MENU PAGE THAT WILL RUN TO MY CUSTOMER PAGE AND INSERT A NEW LINE - (THIS I CAN ALREADY DO) - BUT THE NEXT TIME A CUSTOMER PRESSES A BUTTON I WANT IT TO INSERT A NEW LINE "UNDERNEATH" THE LINE THAT WAS INSERTED PREVIOUSLY......

IN BREIF - HOWE DO I INSERT A NEW LINE EACH TIME?????? FROM MY MACRO? - PLEASE E-MAIL ME....

THANX - ANY HELP WILL BE APPRECIATED.


Posted by JuBo KeTat on December 31, 2001 6:28 AM

he..dont you go to school before ?

Posted by Barrie Davidson on December 31, 2001 7:43 AM

Richard, what is the cell address where you first insert a new line?

BarrieBarrie Davidson

Posted by richard on December 31, 2001 8:26 AM

>>>> what?

Posted by Richard on December 31, 2001 8:33 AM

Cell a14:i14

then i want it to do the next line down (each time) the button is pressed.

Posted by Barrie Davidson on December 31, 2001 8:39 AM

Is there anything underneath cell A14? What I am thinking you could do is:

• Go to cell A14
• End+Down
• Check the cell address
• If the cell address is A65536, go back to cell A14 and insert the line.
• If the cell address is not A65536, go down one row and insert a row.

Would this work?

Barrie

Barrie Davidson