Hi,

I have a spreadsheet that i run a macro on to trim it down into a table and
then paste it into Word. I would like to be able to do two things: -

1. How would i set the range as a variable so that, should the range change
in future, the VBA script will not display any errors?

2. I would like to be able to delete or hide rows that do not have any data
(based on the variable range in question 1). Not all of the columns have data
so i cannot sort this by using a filter.

The more complete code, the better as i am a learning novice.

Thank you in advance,
Paul.

--
Message posted via http://www.officekb.com