Using Select Case rather than If/then in Excel


	ASP Shopping Cart, Forum & BBS - all for $20 from CodeToad Plus!

Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM

Search Site:

CodeToad Forums » Visual Basic » Using Select Case rather than If/then in Excel	Search Forums:

Using Select Case rather than If/then in Excel

Boggie at 18:20 on Thursday, December 30, 2004

Hi,
I am working on a detailed vacation tracking sheet for work (fire department). I am trying to search a column for any rows that contain data other than 0. If they do then enter them ,in the order they were found, in a single cell, seperated by semi colons.

If then statements just get too confusing, and i am not familiar with Select case.

If you need a snippet of the sheet , let me know.

Thanks in advanced.

Useful Links

Web Hosting

Web Site Templates

Domain Names

Ram Upgrades

Cheap Web Hosting

Web Hosting Services

ASP.NET Hosting

CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums

Recent Forum Threads

•	Help! IFrames!
•	Re: after updation of a table open another program .. need help
•	Re: Link doesn`t display full file name
•	Re: Passing a resultset from a servlet to JSP
•	Re: Help: Trouble with z-Index and SELECT lists
•	Re: Hide Column
•	Re: text field multiple
•	Re: crystal report - Logon failed.
•	RadioButtonList Formatting: Multiline Text Aligning

Recent Articles

	Communicating with the Database (Using ADO)
	MagicGrid
	Simple Thumbnail Browsing Solution
	Type Anywhere
	A Better Moustrap: FmtDate to replace FormatDateTime
	ASP.NET Forum Source Code
	Internal Search Engine
	Javascript Growing Window
	Simple date validation
	Search engine friendly URLs using ASP.NET (C#.NET)

Site Survey

Help us serve you better. Take a five minute survey. Click here!

submit a link - privacy - contact - advertise - hot links - link to us - submit your article