ereborn

Thanks so much ... I solve it Your tutorials are good. I found everything what I needed Thank again.

Thanks a lot for advice ... I try links you sent and I try to solve my problem. Bye

A bit old topic but maybe you didn't solve your problem. Try to run Visual Basic Editor (ALT+F11) On the left side you can see two windows with PROJECT and WORKSHEET properties In the upper one (PROJECT) you can find Microsoft Excel Objects and Modules Open MODULES and there is list of all macros you made. If only one there is your Macro ... Rightclick at Module1 (name of macro) and Remove module Dialog will appear with question to save or export deleting module. If you don't need it simple remove the module. Save and try to open.

Hi there I would like to please some1 to help me with usin VBA scripts in Excel to copy value from one sheet to another. Due to I can't programm in VBA I tried to set up a makro to do it and then I copied it to ONBUTTONCLICK event. But it does not work ... because it writes some error. Sub Makro1() ' ' Makro1 Makro ' Makro set up 10.2.2006 by ereborn ' ' Shortcut keys: Ctrl+h ' Range("B3").Select Selection.Copy Sheets("Sheet2").Select Range("B3").Select ActiveSheet.Paste Application.CutCopyMode = False Sheets("Sheet1").Select Range("B4").Select Selection.Copy Sheets("Sheet2").Select Range("B4").Select ActiveSheet.Paste Application.CutCopyMode = False End Sub This one above works perfect ... BUT Private Sub CommandButton1_Click() Range("B3").Select Selection.Copy Sheets("Sheet2").Select Range("B3").Select ActiveSheet.Paste Application.CutCopyMode = False Sheets("Sheet1").Select Range("B4").Select Selection.Copy Sheets("Sheet2").Select Range("B4").Select ActiveSheet.Paste Application.CutCopyMode = False End Sub This one doesn't ... It is same as makro in CTRL+H but this writes error : Error during processing '1004' Method SELECT of class RANGE failed I don't know how to solve this problem ... Problem is only if I need to copy something between 2 sheets. In one sheet it works perfect. Could some1 help ? Thanx in advance