Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default insert row on next sheet


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert sheet tab is not functioning and can't add new sheet LoLo Excel Worksheet Functions 5 April 2nd 23 07:06 PM
Can not insert sheet??? S Davis Excel Worksheet Functions 2 March 15th 07 06:41 PM
insert query into excell sheet to update excell sheet and pivot table vbsolo Excel Discussion (Misc queries) 0 August 24th 05 12:41 PM
Insert Sheet No Name Excel Programming 2 May 20th 04 09:18 PM
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 Hannes Heckner Excel Programming 1 March 5th 04 09:10 AM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"