Three questions:
1. What is the actual formula you're trying to generate (in A1 notation)?;


2. Why are you using R1C1 notation?
3. Why are you referencing ActiveCell rather than specifying a cell address?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Speaking as an R1C1 bigot, I snap back that he's using R1C1 because that's the natural and proper way for programmers to think. Don't let him talk you out of it, jingo. Bully for you!

But you didn't say what error message you get, and that's a critical part of the puzzle. You really must learn not only to tell us how (exactly) your code is failing, but to look at that message carefully yourself. It seems to me there's a fundamental problem in the statement; count the quote marks and see for yourself. That statement would never be accepted by the VBA editor. There has to be one more quote in your program somewhere, perhaps like this:Paul, the translation of that R1C1 formula depends on where ActiveCell is. Pretend it's in T50; in that case If numyear=14 and tillww=5 then in the worksheet it comes outThat's still wrong; there needs to be a comma between "14" and "M:M". Jingo, I think you have to change your statement toBut it'd probably be even clearer if you made the references absolute:Also, I think Paul's third question is a good one.