Posted to microsoft.public.excel.programming

Nena[_2_]

external usenet poster

Posts: 20

VLOOUP

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOUP	Matt	Excel Discussion (Misc queries)	2	January 24th 08 04:41 PM
vlooup with an if statement?????	samiauthor	Excel Worksheet Functions	2	August 14th 07 03:43 PM
vlooup formula and if(),isna etc	Claudia	Excel Worksheet Functions	3	May 29th 07 01:17 PM
Linking cells (VLOOUP/IF function maybe?)	GregA	Setting up and Configuration of Excel	2	August 20th 06 01:15 AM

All times are GMT +1. The time now is 11:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us