Macros use VBA coding.

But using VBA wouldn't increase the file size appreciably, at least for what
you're trying to do. Unfortunately, the precise coding you're looking for is
out of my knowledge level.

Perhaps try RagDyer's suggestion?

"JAZZNAURA" wrote:


Thanks for the reply.

The formula would not give me the flexibility if the value returned was
higher or lower, would it RagDyer? Sorry if I didnt make myself clear,
may need to highlight 6 cells of 60, depending on the value return by
vlook up formula.

Dave F, when you say vba programming, do you mean a macro? If so reason
for not using is to keep file size to minimum, hope Im correct in my
thinking here.

Apologies if Ive made incorrect statements here.

RayDyer, Is the formula flexible in that sense?

Dave F r u talking about a macro and would it be simple to do?

cheers again


--
JAZZNAURA
------------------------------------------------------------------------
JAZZNAURA's Profile: http://www.excelforum.com/member.php...o&userid=36961
View this thread: http://www.excelforum.com/showthread...hreadid=572793