Posted to microsoft.public.excel.programming

Peter Hesselager Peter Hesselager is offline

external usenet poster

Posts: 18

VLOOKUP in a Macro

I can't make the Data_value work

for I = 170 to 182
IF I = VLOOKUP(I, DayNr,1) THEN
something
ENDIF
Next

I = actual daynumber
DayNr is a range of Working day No.

If I substitute "I" with a value ( say 170), it works OK.
The goal is to decide, whether I is a working day or not.

How should it be written ?

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
Macro - Vlookup	orquidea	Excel Discussion (Misc queries)	6	May 14th 08 04:42 PM
vlookup macro	MikeD1224	New Users to Excel	1	June 16th 07 04:37 AM
VLOOKUP in a macro??	chip_pyp	Excel Discussion (Misc queries)	1	March 27th 06 09:40 PM
VLOOKUP MACRO	JOHN YOUNG	Excel Programming	2	July 23rd 04 10:21 PM
Need a macro to do what this VLOOKUP does	Tim	Excel Programming	5	February 12th 04 04:41 PM

All times are GMT +1. The time now is 03:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us