Good morning
My goal is to transpose these 2 lines into vba (in this case 6 lines)
That is, what I want is to repeat the whole information but then I just want to have a privileges column even if I have repeated all the rest of the information
DimcountprivilegiosAsIntegerDimlinhaAsIntegerDimcolunaprivilegioAsIntegerDimfolhaorigemAsStringDimfolhadestinoAsStringDimuserlinhaAsStringDimnomelinhaAsStringfolhaorigem="Extração Enterprise User InaAct"
folhadestino = "Extração Enter UsersInaActiv"
linhafolhaorigem = 2
colunaprivilegio = 18
userlinha = ""
nomelinha = ""
Do While linha <> ""
Do While colunaprivilegio <> ""
'(o que devo colocar aqui)
imprimir folhaorigem, folhadestino, linhafolhaorigem
colunaprivilegio = colunaprivilegio + 1
Loop
linha = linha + 1
Loop