Could you please supply the code?

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"jongdg " wrote in message
...
This is probably a simple problem. There are certain macro's that I
want to assign a command button to. I have no problem if the macro
functions within the sheet that contains the button. But, if the macro
calls for information contained within a different sheet, the macro
fails. The strange part is that these macro run fine if there not
assigned to a command button. But once the same macro code is copied
into the private sub of a command button, it fails.


---
Message posted from http://www.ExcelForum.com/