danomaniac I need your help!

[fanch72]

Hi Danomaniac,
your script did work perfectly on my computer at home yesterday but not on my PC at my job. I keep getting the following error:
"Subscript out of range" for the line
Set oldtable = ThisWorkbook.Sheets("OldTable&quot

what do you think that means?

Thanks again

Francois

 

[GlennUK]

Check that the workbook that you are running the VBA from has a sheet called "OldTable". ( exact spelling, no trailing spaces )

What the message means is sheet not found.


Glenn.

 

[fanch72]

Thanks. You're right. The problem was that I had copied the script in the wrong workbook. My mistake and sorry...
Francois

 

[danomaniac]

Francois
Sorry I didn't respond sooner, but glad you got it. Thanks Glenn.