Using Select Case

**brentjohn** · 05-01-2023, 12:41 PM

Greetings,
I am needing to transfer cell information from one worksheet to multiple worksheets. The information will need to be entered by use of "Select Case". Using the following code, the Select Case is only referencing the first cell and not the others. Because I have several cells to refence, I would like to minimize the mount of code.

Please Login or Register  to view this content.

**Bernie Deitrick** · 05-01-2023, 01:13 PM

Try it like this:

Please Login or Register  to view this content.

**brentjohn** · 05-01-2023, 01:36 PM

Mr. Deitrick,
Works perfect!!! Thank you much!!!

**Bernie Deitrick** · 05-01-2023, 01:52 PM

I didn't really pay attention to your actual entries - you may want to enter numbers into your cells rather than strings:

Please Login or Register  to view this content.

become

Please Login or Register  to view this content.

**brentjohn** · 05-01-2023, 01:58 PM

It actually works using the "". What is the difference between numbers and strings?

**Bernie Deitrick** · 05-01-2023, 02:09 PM

If you use MATCH or other functions like VLOOKUP that perform a match, numbers and strings don't actually match. And math sometimes works (multiplication) and sometimes doesn't (SUM). In general, if you want a number, use a number.

**brentjohn** · 05-01-2023, 02:14 PM

Makes sense - thanks for clarifying!

Using Select Case

LinkBack

Thread Tools

Rate This Thread

Display

Using Select Case

Re: Using Select Case

Re: Using Select Case

Re: Using Select Case

Re: Using Select Case

Re: Using Select Case

Re: Using Select Case

Thread Information

Users Browsing this Thread

Similar Threads

Select case inside a select case

[SOLVED] Select Case with multiple lines in a case statement?

[SOLVED] Need the proper syntax to use Case/Select Case in vba properly.

[SOLVED] Disregard case in VBA code. (UCase, LCase, Select Case)

Case Select compile error "Case without case select"

Case Select....The alternative method for long "Select Case"

Select case / case is, multiple arguments

Bookmarks

Bookmarks

Posting Permissions