Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert and copy a row in Excel

Status
Not open for further replies.

Bruce007

Programmer
Mar 13, 2002
30
US
I need to know how to insert a row into an Excel spread sheet. I know how to open the sheet and get to the row belw where I want to Insert the row, but I can't seem to find that next step. I also need to know how to copy the row above the new row into it.
 
A good general solution to manipulating Office apps from VB is to record a macro, then copy and paste the code into your VB app. You will need to change the references, but you seem to be past that stage anyway!

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top