Posted to microsoft.public.excel.programming

NateBuckley NateBuckley is offline

external usenet poster

Posts: 146

VBA - Finding the odd one out

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding max value	millwalll	Excel Programming	4	January 3rd 08 11:02 PM
Finding Same Row Value	JN[_6_]	Excel Programming	4	May 26th 06 04:43 PM
Finding Row	fak119	Excel Discussion (Misc queries)	3	May 18th 06 05:54 PM
finding value	ceemo	Excel Discussion (Misc queries)	4	April 20th 06 02:16 PM
Finding a sum	Realwoodies	Excel Programming	3	February 25th 04 11:46 PM

All times are GMT +1. The time now is 04:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us