Posted to microsoft.public.excel.programming

Catalin[_2_] Catalin[_2_] is offline

external usenet poster

Posts: 16

Create Select Case Function

COLUMN A COLUMN B
Apple 1
Orange 2
Kiwi 3
Apple 1
etc.
What should be the VBA code to auto fill the column B given the values of
column A. A couple of years ago I solved this problem but can not remember
how I did that, all I remember is that I created a function (that included
the select case because of the number of entries) and accessed it from the
worksheet.
Thanks

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
countif function: how to distinguish case/make case sensitive	mvwoolner	Excel Worksheet Functions	3	March 18th 09 02:18 PM
Select Case	jlclyde	Excel Discussion (Misc queries)	5	January 6th 09 09:05 PM
Case without Select Case error problem	Ayo	Excel Discussion (Misc queries)	2	May 16th 08 03:48 PM
Excel Custom Function with Select Case	Heather[_7_]	Excel Programming	14	November 6th 03 11:37 PM

All times are GMT +1. The time now is 01:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us