Trouble Copying Vba Subroutines

  • Thread starter Thread starter kathleane
  • Start date Start date
K

kathleane

Running Excel 2000 in Windows ME.

When I copy a subroutine from one workbook to another it doesn't always
work. The items that seem to get "lost" are conditional formatting,
cell formatting and shortcut keys. I've examined the newly pasted
subroutine line by line and it's all there just as it was in the
previous workbook in which it worked correctly. I've tried running the
subroutine with both the original workbook open and with it closed but
get the same incorrect result both ways.

Is it not possible to have the same subroutine in two different
workbooks?

I could of course rewrite the subroutine in the new workbook, but I was
hoping to save myself hours of work.

Can you help?
 
Probably a good idea to post a few of the lines of code that do not see
to work (this might help you debug too, by testing them on their own).

If you have any On Error lines comment them out temporarily so you ge
a more helpful error message
 
Back
Top