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
