View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NSNR NSNR is offline
external usenet poster
 
Posts: 20
Default calling macros from worksheet to another

I have created a macro in sheet1 and stored it in view code of sheet1.
Now I copy the contents to sheet1 and also the viewcode to sheet2, but it
does not work. Can anyone help me in this matter.

Also How can I access or refer data/cells from one worksheet/Excel file in
other worksheet/Excel file while creating macros.
NSNR
--
reply to my posts are welcome