View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sauron[_3_] Sauron[_3_] is offline
external usenet poster
 
Posts: 1
Default VBA insert messing up Vlookup and Match

Hi All,

Just wondering if anyone had run into the problem of when you update a
column with VBA then all your VLookup and Match references pointing at
it become #REF.

Is there a way to stop this happening because its kind of annoying :/

Cheers again,
Sau


---
Message posted from http://www.ExcelForum.com/