(Solved) – what does mean .cells(i).resize(j,k)?

  • by
(solved)-–-what-does-mean-cells(i).resize(j,k)?

I have a vba code where I have needed to copy cells between sheets,

I have used this :

If .Cells(1).Value = "MyValue" Then

    .Cells(3).Resize(1, 2).Copy trg3.Cells(k, "C")                 

     k = k   1

End If 

And it works,

Now, I need to copy other columns and rows, apparently first time I was just lucky 🙂

because I didn’t understand really the meaning of “.Cells(3).Resize(1, 2)

Thanks in advance,

Leave a Reply

Your email address will not be published. Required fields are marked *