danovkos
08-02-2010, 03:31 AM
hi,
pls. i can not figured out, how to do following.
I have sheet1 and there is a button
i have sheet2 and there are data.
When i am in sheet2 with data i make copy (Application.CutCopyMode is true) and now i select sheet1 and want, when i press this button, that it add value from CutCopyMode set to value "numberID".
i know, that i can not use activecell, because i am in other sheet with other cell. I dont know, how to add value (which is copying- cutcopymode true) set to variable. :(
i tried this, but (of course) it is wrong.
numberID = ActiveCell.Application.CutCopyMode
any suggestions?
thx a lot
pls. i can not figured out, how to do following.
I have sheet1 and there is a button
i have sheet2 and there are data.
When i am in sheet2 with data i make copy (Application.CutCopyMode is true) and now i select sheet1 and want, when i press this button, that it add value from CutCopyMode set to value "numberID".
i know, that i can not use activecell, because i am in other sheet with other cell. I dont know, how to add value (which is copying- cutcopymode true) set to variable. :(
i tried this, but (of course) it is wrong.
numberID = ActiveCell.Application.CutCopyMode
any suggestions?
thx a lot