Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi, I tried to write a macro in Excel VBE for the following procedure, bu I was not succesfull. Can someone help me? Thanks in advance! When a row is inserted on the worksheet "Begroting Calc", the rownumbe of the inserted row should be found in column B on the next workshee (Activesheet.Next.Select). In column B on that next sheet there ar formulas. In row 3 column B that is =ROW('Begroting Calc'!K12), in ro 6 column B that is =ROW('Begroting Calc'!K13) and so on. When the number is found in column B on that next sheet, there shoul be 3 rows inserted underneath the row where the number is in -- leonida ----------------------------------------------------------------------- leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537 View this thread: http://www.excelforum.com/showthread.php?threadid=55637 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
insert sheet tab is not functioning and can't add new sheet | Excel Worksheet Functions | |||
Can not insert sheet??? | Excel Worksheet Functions | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Insert Sheet | Excel Programming | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |