Thanks Joel, I'll give it a whirl now.

I wanted to leave out what I wanted to do with the data afterwards, because
I didn't want anyone going to the trouble of then writing all that code for
me, as what you've just told me is precisly what I needed.

Cheers!

"Joel" wrote:

I forgot to mention you need to use the MOD function not the %

a = 10 Mod 2

"NateBuckley" wrote:

I have a list of data that follows like so:

A01
A02
A03
A04
A05
A06
A07
A08

I wish to Display only the Odd ones, so A01, A03, A05, A07 and so on, I know
the formula to do this but have no idea how to do it in VBA with code.

I'm guessing it's something to do with the % operator?

Thanks for any help