Merging multiple worksheets

[dagindi]

While researching merging multiple worksheets I came across the following macro authored by Jerry Beaucaire:

Please Login or Register  to view this content.

The above code works fantastic if you are not range specific.

I was then provided with the following tweak to select the ranges I need consolidated:

Please Login or Register  to view this content.

I am now getting a run time error '1004 "That command cannot be used on multiple selections" and the selection below is highlighted.

Please Login or Register  to view this content.

Any suggestions on the fix for this?

[Richard Buttrey]

Hi,

Try just

Please Login or Register  to view this content.

instead.

HTH

[JBeaucaire]

We left in the .EntireRow, you're not copying the entire row any more.

Please Login or Register  to view this content.