troubleshoot xlUp xlDown error 1004

Hi,
The enclosed code splits text into two columns and autofills down the formula for all the rows that contain data.

The text in column A may look something like this:-

Jim Smith 01/12/2009
Francis Marie Johnson 12/01/2010
Mike 13/01/2010

It separates the data by taking the last 10 charatacters and converting them to a date, and the preceding characters appear in a column on their own.


When running the macro on most computers it works fine, but on one particular computer a user gets an Error 1004 Application Defined Error. It seems to fail when finding the top or bottom cell in the range and cannot autofile down because of this.

Any suggestions as to why this may not work on all computers?

Please Login or Register  to view this content.

Thanks,
LowSociety

I think that computer runs Excel 2007 ?

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

You've got lots of selecting and working with the activecell which is generally not necessary.

Does this do what you want?

Please Login or Register  to view this content.

Dom

This should work on all your systems.

Please Login or Register  to view this content.

If I guessed at the columns to insert incorrectly, edit that...