Yes, I read that but, I don't understand where in the series of commands do I
insert the additional function. The directions don't provide enough detail
for a novice.
--
Melanie


"Ron de Bruin" wrote:

Hi Melanie

When you read the information above the macro it say

Important:
The macro examples use the LastRow or LastCol function that you can find in the last section of this page.

So copy the function also in the same module as the macro.
Let me know if you need more help



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Melanie" wrote in message ...
I've tried the VB scripts provided and they error out at:

'Find the last row with data on the DestSh
Last = LastRow(DestSh)

--
Melanie


"Ron de Bruin" wrote:

Hi Melanie

Try this example with aexample workbook
http://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Melanie" wrote in message ...
I have 13 worksheets that I need to consolidate onto one sheet. I've tried
using codes from VB and they error out or give unwanted results.

I want to use consolidate from the data tools group. I've followed the steps
provided by help and even though the function appears to execute; no results
show. Can someone help me out?

--
Melanie