Posted to microsoft.public.excel.programming

Sauron[_3_] Sauron[_3_] is offline

external usenet poster

Posts: 1

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/

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
vlookup retunrning a match, when not a match...	Dave Peterson	Excel Worksheet Functions	1	October 2nd 08 11:22 PM
vlookup retunrning a match, when not a match...	mark	Excel Worksheet Functions	4	October 2nd 08 10:39 PM
vlookup retunrning a match, when not a match...	Niek Otten	Excel Worksheet Functions	0	October 2nd 08 09:00 PM
index Match, or Vlookup Match..	news.transedge.com	Excel Worksheet Functions	1	August 3rd 07 02:00 AM
Tab character is messing me up	Some Dude	Excel Discussion (Misc queries)	4	June 27th 06 11:43 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us