Search and change! (not and destroy!)

As for the spreadsheet data you can use Edit\Replace or Ctl-H and input 1-2006.xls to be replaced by 1-2007.xls

As for the code if you are referencing items that will change frequently it is best to set them to a constant at the top of your module. This way you only have to replace it where it is defined.

Originally Posted by mhax

Ok i got alot of cells in my files where there is "=VLOOKUP(...)" function! There's two files that the VLOOKUP function can search in. Let's say 1_2006.xls and 2_2006.xls! I need a macro that will search in all function for thoses files and change the names files to 1_2007.xls and 2_2007.xls! There is also some call of those files in some macro! So the "Macro" has to also change the name of files in the other macros! Would be could if there would be an Inputbox where the user could write the year he want the new files to be! Any idea? Thanks for the help!

Maxime