Macro Errors that no one else is getting?

[csynic]

Hi everyone, i have a macro file (X) which draws data from 2 other excel files Y and Z. It then makes changes to file Y, leaving Z untouched.

The way to use it is to open X Y Z and run the macro from Y. However, an error message pops up when i'm running the second part of the macro

Run time error 9, subscript out of range

on debugging, i find the error occurring at this line:

Please Login or Register  to view this content.

does anyone know what's happening? my friends tell me it runs fine on their computers, but i cant get rid of this error. does it have to do with excel error-ing when trying to find the last filled cell? thanks for the help!

[csynic]

i figured out the problem - turns out that hiding my file extensions does the trick. any idea why?

i'm guessing the workbook referenced in the code does not have a .xls extension, can anyone confirm this?

[snb]

confusing information:

error is occurring in this line
and then you show 2 lines

Solution:

Please Login or Register  to view this content.

The error message indicates whether:
- there's no Workbook "Surgeon Allocation.xls"
or
- there's no sheet "Sheet1"

[romperstomper]

FYI, if you use:

Please Login or Register  to view this content.

then it will work whether extensions are shown or not.

[csynic]

confusing information:

error is occurring in this line
and then you show 2 lines

Solution:

Please Login or Register  to view this content.

The error message indicates whether:
- there's no Workbook "Surgeon Allocation.xls"
or
- there's no sheet "Sheet1"

sorry what i meant was the error was in the first line. i just showed the second line for clarity. in fact, the code does not have the .xls, so it should read

Please Login or Register  to view this content.

does this mean that the macro will not work if i set file extensions to be visible in windows?

[snb]

Please read the answers carefully.....