manually it works in macro it don't

Posted by warren on November 10, 2000 4:27 PM

i am trying to open a form in a list to add data and delete data. my problem is my macro calls up an emptry form(the headings are correct, but there is no data in the form) When i recorded the macro it worked, when i run the macro it doesn't.

Posted by Ivan Moala on November 11, 2000 3:49 AM

Does this help ??
5405.html

Ivan

Posted by warren on November 13, 2000 4:05 PM

i tried that and it still doesn't work

Posted by MR Green on November 18, 2000 3:34 PM

it's a MS bug, try this workaround Workbooks("YourWorkBook.xls").Sheets("sheet1").Cells.Copy
ActiveSheet.Paste
Workbooks("YourWorkBook.xls").Sheets("sheet1").Select

Posted by warren on November 22, 2000 4:45 AM

thanks for the pointer MR