Hi All,

Does anyone know of a VBA procedure to Replace words in Formulas found
on a Sheet?

I have a Dashboard worksheet which has VLOOKUP formulas referencing
different fles which are according to months.

If i create a copy of the files & change their names to reflect the
current month, i have to go ahead & edit the Vlookup formulas on the
Dashboard worksheet to get data from the current month's files.

Since i file naming convention like:

XXXXXXX-May-06.xls
XXXXXXX-Jun-06.xls.....

Is there a VBA procedure which can look for May-06 & replace it with
Jun-06???

Warm Regards,

Junoon

junoon wrote:
Hi All,

Does anyone know of a VBA procedure to Replace words in Formulas found
on a Sheet?

I have a Dashboard worksheet which has VLOOKUP formulas referencing
different fles which are according to months.

If i create a copy of the files & change their names to reflect the
current month, i have to go ahead & edit the Vlookup formulas on the
Dashboard worksheet to get data from the current month's files.

Since i file naming convention like:

XXXXXXX-May-06.xls
XXXXXXX-Jun-06.xls.....

Is there a VBA procedure which can look for May-06 & replace it with
Jun-06???

Warm Regards,

Junoon

What's wrong with Find & Replace?

Paul Lautman wrote:
junoon wrote:
Hi All,

Does anyone know of a VBA procedure to Replace words in Formulas found
on a Sheet?

I have a Dashboard worksheet which has VLOOKUP formulas referencing
different fles which are according to months.

If i create a copy of the files & change their names to reflect the
current month, i have to go ahead & edit the Vlookup formulas on the
Dashboard worksheet to get data from the current month's files.

Since i file naming convention like:

XXXXXXX-May-06.xls
XXXXXXX-Jun-06.xls.....

Is there a VBA procedure which can look for May-06 & replace it with
Jun-06???

Warm Regards,

Junoon

What's wrong with Find & Replace?


I have around 300 cells referenced from 15 different workbooks & each
Vlookup done is for different types of Data (Numeric, Text etc).