I have a macro that pastes data as values to a worksheet. After paste is done I need a method to delete all of blank rows and columns, order of delete is not important.

Problem is the that pasted data field contains blank cells in an otherwise populated row and/or column which need to remain and should not be deleted. Need help to figure out a method of taking out entirely blank rows and columns of the pasted data in a macro. Note this function must use the pasted data only and not the original user selected copied data

Another method I am trying to stay away from is to sort data rows/columns in descending order which would then force the blank rows and columns to the outside edge of the data field. Doing this will change the original sort order that user is not comfortable with

Thank you in advance for all of your invaluable sugestions and assistance in this matter

Floss

Hi
have a look at
http://www.cpearson.com/excel/deleti...eleteBlankRows

--
Regards
Frank Kabel
Frankfurt, Germany


floss wrote:
I have a macro that pastes data as values to a worksheet. After
paste is done I need a method to delete all of blank rows and
columns, order of delete is not important.

Problem is the that pasted data field contains blank cells in an
otherwise populated row and/or column which need to remain and should
not be deleted. Need help to figure out a method of taking out
entirely blank rows and columns of the pasted data in a macro. Note
this function must use the pasted data only and not the original user
selected copied data.

Another method I am trying to stay away from is to sort data
rows/columns in descending order which would then force the blank
rows and columns to the outside edge of the data field. Doing this
will change the original sort order that user is not comfortable
with.

Thank you in advance for all of your invaluable sugestions and
assistance in this matter.

Floss