View Single Post
 
Old 11-06-2013, 10:47 AM
mikec mikec is offline Windows XP 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