View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sune Fibaek Sune Fibaek is offline
external usenet poster
 
Posts: 10
Default Vaiable in range().formula

Dave Peterson wrote:
I bet you have to increase the number of columns in your lookup range, too.

A1:B15????

Hi Dave,

Well, yes it would be hard pressed to find the second row in my range,
wouldn't it? The formula was not exactly a copy-paste job from the
actual code.

Sharp eyes!

/Sune