Program to add a row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Would someone show me the proper way to code a procedure to add a row every
time the word "Subtotal" is found in column B of a spreadsheet. Secondly,
how do I attach this procedure to a button? I'd like the routine to run once
and find every instance of this word and then add the row instead of me
having to do this for each instance of the word. A simple thing, I'm sure,
but I don't know how. Thanks...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Help to copy information from one row at a time to another sheet 1
Programming a button to add a row 1
Auto copy and insert a defined number of rows as defined in a cell 1
Excel Add ^ to a row of cells containing letters 3
Excel spreadsheet to Word document 1
adding verbiage to the end of a cell 1
Go to next row depending every nth iteration 1

Back
Top