Hi, I'm looking for a solution for the following problem:
I have data in more or less the following form:

    A           B
1/1/08    Alex
    "             "
    "             "
13/1/08 Sarah
    "             "
    "             "

The apostrophes meaning that this cell has the same entry as the one above

So what I want to have is my data in the following form:

    A           B
1/1/08    Alex
1/1/08    Alex
1/1/08    Alex
13/1/08 Sarah
13/1/08 Sarah
13/1/08 Sarah

I used the code like in the following thread:

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.
public.excel.programming&tid=00384b45-5fdc-4668-b83d-615ed32fd142&cat=en_US_3a79
3e1f-4961-419d-9ec7-899d6e6086cd&lang=en&cr=US&sloc=en-us&m=1&p=1

It works fine for all symboles except for the apostrophe, because it has
some sort of function in VBA (don't know, because I cannot program in VBA)

Can anyone help me, or do I have to use a different symbol?

Thanks in advance,

Koen