I have 5 worksheets that I put data in. I would like to once a month to be
able to merge this information and have a combined worksheets. I have read
the posts on merging and was able to follow them. But when I put in the code
for merging it comes up with an error - Compile Error- sub or function not
defined.
The code line is
' Find the last row with data on the summary
' and source worksheets.
Last = LastRow(DestSh) (Xxx this is the line i am having a
problem with)
shLast = LastRow(sh)

Is there something that I should be inserting here. I am fairly new to excel
so I don't know anything about the coding.
Thanks for any help.