Using variable in OFFSET function

Is there a way I can use a variable as a parameter in the offset function in VBA. I tried teh following code where cnt3 represents the current column. Its used in a loop.

Please Login or Register  to view this content.

On Sheet2, cell C27 I need to read the values from Sheet1, cell B16. I need to repeat that skipping a column on Sheet2, but not on Sheet1. The loop I created takes me to the correct cell on Sheet two, I just need to figure out how to alter the offset function for each cell. The number of columns can vary each time it runs.

Thanks in advance.