Select Case problem

**saziz** · 08-31-2015, 02:38 PM

Hi,
I am trying to make this macro work, but apparently I am nod doing it right.
Appreciate very much your help in this regard.

Please Login or Register  to view this content.

Thank you
Saziz

**Norie** · 08-31-2015, 02:40 PM

Looks OK to me, how isn't it working?

PS Can you add code tags when posting code?

**saziz** · 08-31-2015, 02:46 PM

I apologize, here it is:
It say "Object variable or With block variable not set"

HTML Code:

**jaslake** · 08-31-2015, 02:51 PM

Hi saziz

You have pNbr defined as range

Please Login or Register  to view this content.

Probably should be

Please Login or Register  to view this content.

**saziz** · 08-31-2015, 03:07 PM

Thank you Jaslake, It worked perfectly.
Saziz

How do I mark "solved" I forgot it has been a long time I was here..

**jaslake** · 08-31-2015, 03:50 PM

Hi saziz

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

Select Case problem

LinkBack

Thread Tools

Rate This Thread

Display

Select Case problem

Re: Select Case problem

Re: Select Case problem

Re: Select Case problem

Re: Select Case problem

Re: Select Case problem

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Select Case problem

select case problem

select case problem

Problem with Select Case construction

Long Select Case Problem

[SOLVED] Having Problem with Select Case

Select case and Last Cell Problem

Select Case Statement Problem

Bookmarks

Bookmarks

Posting Permissions