Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Inserting rows incrementally using a macros button

What I meant is

I have 4 employees displayed per week and 52 weekly charts. there is one
line in bewtween each week chart. I need to add a row after the employee on
row 10. When I use the button again I would like to insert the row on row 11,
then 12. This means that any employees added after the current ones will be
underneath each other.

A the moment I have no code for this as I don't know how to write it.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 812
Default Inserting rows incrementally using a macros button

Selection.Offset(1, 0).Insert Shift:=xlDown

Hth,
Merjet

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
Incrementally Updating worksheets in a workbook Colin Hayes Excel Discussion (Misc queries) 9 April 25th 11 03:19 PM
Inserting a Graphic on a Button when the Button is Assigned to a M smck Excel Discussion (Misc queries) 2 October 27th 09 04:46 PM
How do I copy and paste cells incrementally? Slimmyy Excel Worksheet Functions 5 March 18th 05 12:26 AM
List incrementally? Mark Jackson Excel Worksheet Functions 3 January 14th 05 07:49 PM
Inserting rows from a command button jontait[_11_] Excel Programming 3 May 19th 04 02:16 PM


All times are GMT +1. The time now is 07:26 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"