Select Case problem

[saziz]

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]

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

PS Can you add code tags when posting code?

[saziz]

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

[jaslake]

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]

Thank you Jaslake, It worked perfectly.
Saziz

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

[jaslake]

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.