LinkBack URL
About LinkBacks
The Else clause is not having the desired effect of putting "PYNB" text in cells AF in this instance and with no compile error, I cannot troubleshoot what the problem is?
Please Login or Register to view this content.
The Else clause is not having the desired effect of putting "PYNB" text in cells AF in this instance and with no compile error, I cannot troubleshoot what the problem is?
Please Login or Register to view this content.
Not tested but I don't think you need the IF statement:
Please Login or Register to view this content.
Dom
Last edited by Domski; 12-07-2010 at 08:09 AM.
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
You don't nee the IF.
EDIT: confirms Domski. The IF is only able to check one value because the Select Case liniting the value to 2010Please Login or Register to view this content.
Last edited by royUK; 12-07-2010 at 08:15 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Originally Posted by royUK
You don't nee the IF.
EDIT: confirms Domski. The IF is only able to check one value because the Select Case liniting the value to 2010Please Login or Register to view this content.
Much appreciated and I learnt about the IF statements. thanks
Last edited by Poulan; 12-07-2010 at 08:38 AM.
Either mine or Roy's code should work fine.
Dom
The code has already been edited to remove the problem lines, both are identical.
I would also suggest that you get into the habit of using the sheet in the code as well
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks