It does that when the sheet name in the formula does not match any sheets in
the workbook. For example, when I first put tested it, I had an extra space
after the second 'Fall 2006 Cohort ' rather then 'Fall 2006 Cohort' and
got the same thing. Once I corrected the sheet name in the formula it went
away. If you believe your formula is correct, then check the actuall sheet
name and make sure it doesn't have an added space on one of the ends or
inside the name.
--
Regards,
Tom Ogilvy
:
Thanks Tom! It now runs however when the macro runs through each cell
it gives me a pop box (the one that asks if you would like to save or
open etc) and then it proceeds to the next cell. Any idea why this
might be occurring?
On Aug 29, 9:52 am, Tom Ogilvy <
[email protected]>
wrote:
The code runs fine for me in xl2003. This would indicate that there is
nothing inherently wrong with your code.
The problem is likely to be related to your environment when you run the
code.
--
Regards,
Tom Ogilvy
:
When I try to run this macro I pop box says, "Excel cannot complete
this task with available resources. Choose less data". What am I doing
wrong?
ActiveCell.FormulaR1C1 = "=IF(ISNA(VLOOKUP(RC[-5],'Fall 2006 Cohort'!
R2C1:R65536C28,13,FALSE)=TRUE),"""", VLOOKUP(RC[-5],'Fall 2006
Cohort'! R2C1:R65536C28,13,FALSE))"
ActiveCell.Offset(0, 1).Select
Thanks in advance.- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -