Auto Add formated Row on Enter key

J

JRamses

I'm trying to do a sales report that has a solid continuous border and a
dotted interior. When i get to the last formatted row within the
borders(columns A-G, rows 9-50) and i press enter in row 50 column G i want
it to add another row that pushes the solid continuous border down to row 51
and does the dotted interior. Can anyone provide insight or code?
 

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

Border formatting row of cells 22
Printing the border format of a repeated row at top of page 0
Macro to Format Multiple Sheets based on "Master" Format 0
How to create a dynamic table based on a set of other nested attributes 0
Copy rows to new sheet based on value in column A 0
insert row when sum of values equals 100 3
Using borders in tables in 2003 6
How do I average a row of 13 enries using the 8 highest in value. 2

Top