View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ML0940 ML0940 is offline
external usenet poster
 
Posts: 47
Default Via code, making 2 named Ranges Indentical, upon change

Hi,
Here is a good one I have been pondering for a while, still, in all my
efforts, I have not gotten what I really need. I am not an Excel-VBA expert,
so I am hoping somebody in here can give some insite.

OK, unforunately, there is no row insert/delete event..WISH LIST

I have 2 seperate named ranges; if I change one, I would like the other to
change and look exactly the same as the one that I just changed.
That means, if I delete a row in one, then I want the other to delete a row
and update all the values in the cells to match precisely. Same if I add a
row.

I hope this makes sense and is this possible?

If may work on a Change event but it is not necessary really; if I change
one, then I don't mind clicking a macro to update.

Thanks in advance!

ML