an another question
i have in excel worksheet naming Page1, Page2, etc.,

in view code vba it is in the order
Page1 then it come
Page10
Page11
after Page 19
there come Page 2
Page 20
Page 21
I have problem with it
while merging worksheet
i want come in order
Page1
Page2
Page3
how to sort this

it take
1
10
100
2
20
200

general in sql we have convert to number

we have the formula to_number(Page XXX, 99999)
the it will come in order
how in excel worksheets?