Activecell offset with Variable

I am trying to find the number of columns and rows containing info in a sheet that will potentially change every update.

I have it figured out except the activecell.offset.activate seems to work except it won't allow me to use a variable.

The code I am using is this

Please Login or Register  to view this content.

It is probably an easy answer but I am stuck.

Thanks in advance.

sgreni