IF statements + vba

[GeorgY]

I have code which is the following:

Please Login or Register  to view this content.

Then I was planning to have it automactially pasted down to the end of the columb, however I keep getting an "Expected: end of statment" error.

Anyone know how I can bypass this?

[royUK]

Looks like you have VBA mixed up with formulas. You don't write a formula like that. Do you mean

Please Login or Register  to view this content.

[GeorgY]

hmm I tried that also..same result

VBA thinks that I should have an "End If" at the end..any other suggestions?

[Paul]

Hello GeorgY,

First, please remember to wrap your code in code tags. (I've done this for you.)

Second, try changing your code to:

Please Login or Register  to view this content.

Along Roy's thinking, this too works:

Please Login or Register  to view this content.

[royUK]

There's a missing =

Please Login or Register  to view this content.

[Paul]

Roy, your's still doesn't work due to the quotes around No and Yes. You need two sets of quotes for each.

[GeorgY]

thanks guys, both of your codes work! (Roy's when I added a second set of "" though)

Appreciate it and I'll try to rememeber to wrap code next time

[royUK]

This works for me

Please Login or Register  to view this content.

Edit: I spotted the quotes were missing, thanks pjoaquin

[royUK]

If you want to fill a range, select the cells then use

Please Login or Register  to view this content.