write value to cell based on contents of another

**Poulan** · 11-09-2010, 06:42 AM

Hi anyone/everyone,

I think my macro is 95% there - no errors but it's not performing any functions either!

I want it to decide if the date in column A is <2010 or >2010 and write a value of "PYNB" if the answer is the former or "IYNB" if it is the latter.

Very simple but I'm using thousands of rows so this will considerably cut my PC's processing time rather than have excel do this as a formula.

If anyone can tell me where I've got things wrong I would be grateful for your help.

thanks
Alan

**royUK** · 11-09-2010, 07:30 AM

You don't need to activate an ActiveSheet

This seems to be what you want

Please Login or Register  to view this content.

**Poulan** · 11-09-2010, 12:27 PM

Super, thanks

**royUK** · 11-10-2010, 06:27 AM

Glad we helped

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

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