white_flag
Active Member
- Joined
- Mar 17, 2010
- Messages
- 331
Hello I have this VBA code (part of the code):
an it is working. I try to change it with
an it is not going
then I puted like this:
not going
any idea?
Code:
Worksheets(Me.Controls("Combobox1").Value).Range("A2:B10").Copy
an it is working. I try to change it with
Code:
ThisWorkbook.Worksheets(Me.Controls("Combobox1").Value).Range(Cells(2, 1), Cells(ActiveSheet.UsedRange.Columns.Count, ActiveSheet.UsedRange.Rows.Count)).Copy
an it is not going
then I puted like this:
Code:
'Worksheets(Me.Controls("Combobox1").Value).Range(.Cells(2, 1), .Cells(10, 2)).Copy
any idea?