Select Case debug

**jrx** · 08-05-2016, 11:42 AM

Basically what i want to happen is in column I there is several product types that i want to replace with a range of values from a separate tab, can't figure out why its not working, keep getting "type match error #13" on the first Case Is line.

For j = 4 To 20000
Select Case Range("I4:I20000").Value
Case Is = "GEM 4000"
Result = Sheets("INPUT").Select
Range("B6:J6").Copy
Sheets("IL Inventory").Select
Cells("j", 9).Paste
Case Is = "GEM 5000"
Result = Sheets("INPUT").Slect
Range("B8:J8").Copy
Sheets("IL Inventory").Select
Cells("j", 9).Paste
End Select
Next j

Please Help
Thanks in advance

**shg** · 08-05-2016, 12:09 PM

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.

Thanks.

**jrx** · 08-05-2016, 12:27 PM

Please Login or Register  to view this content.

**shg** · 08-05-2016, 12:32 PM

Thank you.

You can't compare a scalar value to an array; you need to test one value at a time. I can't tell what the rest of the code is supposed to do. Maybe this:

Please Login or Register  to view this content.

**jrx** · 08-05-2016, 12:38 PM

That worked thanks, but now im getting the same error in the line where I specify the paste location

**shg** · 08-05-2016, 12:41 PM

Sorry, I've made several edits. Try the code in the current post.

**jrx** · 08-05-2016, 12:49 PM

Yep that worked, thanks for the help

**shg** · 08-05-2016, 12:55 PM

You're welcome.

Select Case debug

LinkBack

Thread Tools

Rate This Thread

Display

Select Case debug

Re: Select Case debug

Re: Select Case debug

Re: Select Case debug

Re: Select Case debug

Re: Select Case debug

Re: Select Case debug

Re: Select Case debug

Thread Information

Users Browsing this Thread

Similar Threads

[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"

select case macro error debug

Select Case stops after 1st case

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

Case without select case error

Select case / case is, multiple arguments

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions