Thanks Jacob, damn line breaks :)


--
Regards
Dave Hawley
www.ozgrid.com
"Jacob Skaria" wrote in message
...
Remove the blank line between the below two lines...and Dave's code should
work fine. A space followed by _ is a line separator

lReply = MsgBox("To sort .............

& "To sort Worksheets ...........

'remove the blank line (as below) so that VBE considers this as one line

lReply = MsgBox("To sort .............
& "To sort Worksheets ...........


--
Jacob (MVP - Excel)


"Doehead" wrote:

Hi Dave, I did as was instructed by the website but I got a 'Compile
Error'
any idea why?

"ozgrid.com" wrote:

See http://www.ozgrid.com/VBA/sort-sheets.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Doehead" wrote in message
...
Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name'
but
I
am not sure -- do I have to copy and save it into every worksheet? My
workbook has 43 tabs so far. Thanks

.