Hi i have a worksheet in excel with several tabs.In one of them i start a form that will copy a value from one of the cells.According to this value i have to automatically select some cells from another tab and manipulate them.The problem is that before adding the form,everithing worked just fine,but now after adding the form,the needed cells are selected but not copied anymore .I attached the code so that you will see what i mean:


UserForm1.Show 'show form
.................
................
ActiveSheet.Cells(2, "GX").Select
GX22 = ActiveCell.Value
GXvar = "GX" & count
ICvar = "IC" & count
Range(GXvar, ICvar).Select 'select one row to be copied
Selection.Copy

i = 4 + GX22 'jost some variable to determine where to paste
ActiveSheet.Cells(i, "GX").Select 'select cell where copied code will be inserted
ActiveSheet.Paste


The thing is that the selection is made but "Selection.copy" is not working and when i try to paste,it will just paste what was in the clipboard.

Can somebody help?

thanks