View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
crowdx42[_15_] crowdx42[_15_] is offline
external usenet poster
 
Posts: 1
Default VLookUP ARRAY , how can I make it not relative in macro?


Well I have tried changing the R[484]C[10], reference to the actual cell
reference and this gives me an error.
ie. I changed it to A2:P600 and I got an error on this.
Will have a look again.
Patrick


--
crowdx42
------------------------------------------------------------------------
crowdx42's Profile: http://www.excelforum.com/member.php...o&userid=37749
View this thread: http://www.excelforum.com/showthread...hreadid=573897