Ir para conteúdo
Fórum Script Brasil

AneDnz

Membros
  • Total de itens

    1
  • Registro em

  • Última visita

Tudo que AneDnz postou

  1. AneDnz

    Active.Sheet erro

    Galera, To fazendo uma macro e está dando erro no Active.Sheet. A prog é o seguinte: Sub teste() ' ' teste Macro ' ' Columns("C:C").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("C1").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-1],Tabela_regionalxcentral!C[-2]:C[-1],2,0)" Range("C1").Select Selection.AutoFill Destination:=Range("C1:C15490") Range("C1:C15490").Select Range("J1").Select ActiveCell.FormulaR1C1 = "=RC[-1]/60" Range("J1").Select Selection.AutoFill Destination:=Range("J1:J15490") Range("J1:J15490").Select Columns("A:J").Select Selection.Cut Sheets("BASE VC123 2016.1").Select Range("A566361").Select Sheets("Sheet2").Select Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Application.CutCopyMode = False Selection.Cut Sheets("BASE VC123 2016.1").Select Range("A1048576").End(xlUp).Offset(1, 0).Select ActiveSheet.Paste End Sub Poderiam me ajudar? Obrigada.
×
×
  • Criar Novo...