Automatically add another row when then one above contains data

J

James Kellock

I am trying to automate an excel spreadsheet so that when any value is
entered in any cell it will then create another row below with the same
format as the row above.

For example, I enter a value in cell A1 which is formatted with a
surrounded border.

This then automatically creates another row below with the same format
for that row.

I've tried conditional formatting but only offers minimal formatting of
a thin border.

Can anyone suggest a VB solution please ?

*** Sent via Developersdex http://www.developersdex.com ***
 

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

conditional format fails when copied 1
= cell above last entered data 9
Insert Value into cell automatically when new rows are created/inserted 1
VBA to insert .xlborder if cell value not equal to previous cell 2
Find Text and Insert Row Above 9
Check row above for information if it has contents copypaste empty 1
Programming a button to add a row 1
Insert Row also adds formulas and moves cursor 2

Top