Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 11-06-2013, 10:47 AM
mikec mikec is offline Add multiple rows to Excel 2010 table at cursor position Windows XP Add multiple rows to Excel 2010 table at cursor position Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2012
Posts: 30
mikec is on a distinguished road
Default

Attention CJ and Bob Bridges. I expect we're not allowed bad words here but I just wrote several lines in response to your latest went off in the middle to look something up and came back to an empty message box.
Anyway CJ you say the " program stops running" after the add line. Have you put the add line in a loop?
for RowNo = 1 to 10
Range(myTable).ListObject.ListRows.Add (intCurRow - intHeader)
Range(myTable).cells(intCurRow-intHeader,1).Value="Value for Col. 1 in the New Row"
next RowNo
Will add 10 rows at table row (intCurRow-intHeader) putting the same dull text in the 1st col of each one. The 1st entry will end up 10 rows below the last entry. Apologies for not using the Selection. option but if you no where the new row is to be all you need use is the table name.
If that's not what you want why don't you put your worksheet up on the forum.
I notice that Bob Bridges refers to an article you posted. I haven't seen it. Was it under a different thread? And on the topic of different threads I did post one today about excel table formula problems. If either of you have seen it I would appreciate some feedback.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula that can merge multiple rows with the same ID into one row Hilwey Excel 3 07-08-2015 08:50 PM
Add multiple rows to Excel 2010 table at cursor position Word 2010 and Excel 2010 Mail merge - multiple headers robby Word 3 04-18-2012 06:37 PM
Displaying cursor position within cell MiamiTom Excel 0 11-18-2011 09:02 AM
Add multiple rows to Excel 2010 table at cursor position Setting cursor after last Table of Contents DugganSC Word 1 09-07-2011 11:42 AM
Retrieve position of Cursor - x & y positions SDondeti PowerPoint 0 05-19-2011 11:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft