Hi all,

Just a quick query. I have a macro, which searches through column B o
a spreadhseet and creates new sheets according to the content of th
cell. However, it doesn't accept any cell, which contains more than 3
characters. What should I use in my declaration so that it accepts lon
words?

Cheer

--
Message posted from http://www.ExcelForum.com