MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rows


Posted by Michelle on December 28, 2001 10:26 PM

Dear Mr. Excel,
I have created a data base for work divided by rows. I want to be able to delete the lines that divide the rows in areas throughout my chart without moving the rows up or down. I would like to use these larger areas to write freely in and if I just fill in the lines with "no color" my text is still governed by the lines. How do I get rid of the rows I chose all together within my chart?

Thanks!

Michelle


Posted by Jacob on December 29, 2001 4:59 AM

You want to keep the rows but delete everything in em, right?

Try this

select the rows

then put this line in your code

selection.clearcontents

is this what you needed?

Jacob