Is it possible to Use a cell value to "load" Offset movements?

[Vba Novice]

Good evening all,

I'm attempting to create a macro that uses the cell value of the active cell to move the cell pointer "Down" to a new cell.

This line is hand created: ActiveCell.Offset(16, 0).Select

Is it possible to take the cell value from the "active" cell and load it into the "Offset" statement?

Thanks to anyone able to help with this problem.

[rename]

You can set a variable to the activecell like this

Please Login or Register  to view this content.

[rename]

ActiveCell.Value = i
ActiveCell.Offset(i,

[sky1in5]

hi, for your reference

http://www.excel-vba.com/vba-code-2-6-cells-ranges.htm

[Norie]

Perhaps this.

Please Login or Register  to view this content.

[Vba Novice]

sky1in5 - I appreciate the link, I hadn't discovered this yet.

Norie - Thank you very much, that's exactly what I was looking for.

Thanks to all of you for the replies, I appreciate knowing I can find help when I get stuck.