Good morning,

First VBA Scenario,
I have a worsksheet where I use a macro to do a "Text To Columns" spread of
data by delimeted width into the next column.

When I run the macro, a dialogue box pops up to prompt if I want to
overwrite the cells in the next column. I need VBA code that will force this
overwrite so the macro will not pause and prompt me to overwrite. Any ideas?

Next VBA Scenario,
I get a weekly spreadsheet from our planning department that has several
tabs. The first tab is usually named "Data - Monthly"; however sometimes the
tabs aren't named consistently, for instance, the first tab may be named
"Data- Monthly".

I run a macro that uses this first sheet, and if the name contains typos the
marco errors out. I need VBA code that will NOT try to look for "Sheet 1" or
name of the first sheet, but will simply reference the first Sheet in the
workbook and then name the sheet a name that I give it in the Macro. This way
the sheet name will always be correct when the macro runs. Please advise.

Thanks Much,