Antony21
06-27-2007, 07:21 PM
Hi people!!! :hi:
I'm a new guy in this forum and I need some help with two things..., pleaseeee
In first place, in a Excel workbook, I need to run a macro in sheet 2 by click in a button on sheet 1. It seems to be very easy, but i've tried and so far I failed.
The second thing is, inside that's macro code, select a range of cells, copy them and paste them to another sheet on the same workbook. The copy range varies in accordance to the input of the macro and the paste range also varies. I tried to do something like that:
For t = 0 To Cells(2, 2)
Cells(4, t).Select
Cells(4, t).Copy_ Destination:=Sheets("Resultados").Range("A1").End(xlDown)
Next t
However, once again :(, an error occurs.
Can you guys help me?
Thanks in advance :thumb
I'm a new guy in this forum and I need some help with two things..., pleaseeee
In first place, in a Excel workbook, I need to run a macro in sheet 2 by click in a button on sheet 1. It seems to be very easy, but i've tried and so far I failed.
The second thing is, inside that's macro code, select a range of cells, copy them and paste them to another sheet on the same workbook. The copy range varies in accordance to the input of the macro and the paste range also varies. I tried to do something like that:
For t = 0 To Cells(2, 2)
Cells(4, t).Select
Cells(4, t).Copy_ Destination:=Sheets("Resultados").Range("A1").End(xlDown)
Next t
However, once again :(, an error occurs.
Can you guys help me?
Thanks in advance :thumb