Recent content by vivaruthland

thank u for ur advice. but finally, i could find a way. :) For e = 1 To iEdo 'esto es para el cada estado Cells(14, 14) = iContfVar sNomEdo = Cells(e + 10, 5) & ".xlsx" 'Guarda en -memoria el nombre del Edo If aFinal > 2006 Then...

yeah! this is the idea, and it works in the same workbook that is the macro saved, the problem is that I want to do this in a diferent workbook . ;D

thank u for ur suggestion, but sNome is a string variable that contains the name of the sheet. The big deal is how to select a range in another workbook. I also test this way Workbooks(sNomEdo).Sheets(sNome).Activate...

Hi I want to create a macro with the purpose to call a diferent workbook "Nomedo" and once the workbook is opened the macro should copy and paste a range in this Workbook, but the problem is that the row of the range change, so I can't select a range in this way...