understanding code .cells().resize() ect.

Hi, I am really new at understanding code, I am getting a book for christmas, but in the mean time could someone help me understand what is happening here?

Please Login or Register  to view this content.

Specifically, how does this section work? What does resize mean, what does offset do?

Please Login or Register  to view this content.

I am trying to learn how those parts of the code work becaues I need to move the stuff around. My "current" is in column A, but my numbers do not start until column G

Hello caliskier,

Resize is a Range property that extends the current Range by the number of rows, and columns supplied as arguments and returns a Range object. OK, in simple terms...

Please Login or Register  to view this content.

Offset allows you to calculate a new address using a cell as a reference. Again, we have the Row and Column arguments. These determine which direction to move...

Please Login or Register  to view this content.

If the Row or Column argument is omitted or a zero, the current number of rows or columns stay the same.

Sincerely,
Leith Ross

Thank you, that is very helpful, this has been so confusing to me. Hoping to get some books for Christmas.