Greetings all!
I have a simple bit of code to insert a table row between the 2nd and 3rd row, 1st row is headers. Then I copy line 2 to the newly inserted line 3 then clear contents on line 2. The purpose is to be able to enter data at the top of the table rather than adding rows at the bottom (I'm quirky that way).
Anyway, this is taking 4 lines of code, and it seems to me that it could be shorter. Any Suggestions?
Thanks for taking a look!
Please Login or Register to view this content.
Last edited by jacob@thepenpoint; 12-19-2013 at 10:28 AM.
Jacob Albers
Excel 2003 & 2010
Hi, Jacob
So, rephrasing your earlier post, you have a column of data, with a blank row at the top, just underneath the headers.
You want to be able to add data into the various columns, and at the end of data entry (this is the rub, isn't it) to push everything down and addin a new blank line (ready for the next data entry).
If this is the case, then you can eliminate 99% of your requirements, and say:
At the end of data entry, insert a new row in row 2. (Same caveat about detecting the 'end-of-data-entry' condition.
Does this restructuring make sense?
HTH
Tony
Question: why don't you just insert a row just below the title row (as row number 2)?
Click on the star if you think I helped you
The problem I run into just adding a row below the header is that it copies the format of the header row. This code snippet is the way I was working around this problem. I normally just add the row as I am about to add data.
Try This,
Please Login or Register to view this content.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
Thanks xlbiznes, that works. I just needed to modify it to look at the table only instead of the entire row.
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks