VBA goto cell referenced in a cell

[brianfosterblack]

I am using Excel 2013

In cell L11 I have this formula
Address (K11,7)
This returns the address in the cell as $G$45 but the row number will change each time I loop the macro
In my code I want to go to that address and continue running the code.

to do this, I am using this code
Application.Goto Sheets("Sheet1").Range(Sheets("Sheet1").Range("L11").Value) ' cell reference of where repeats start

I am running into an error on this line of code and do not understand why

I have 2 worksheets in the workbook but Cell L11 is on the same sheet as the code is running on (sheet1) named as Log Book

 

[My Aswer Is This]

Please explain in words with specific details what your wanting your script to do.
And I will see what I can do to help you.

Normally we should not need to use a Goto

 

[brianfosterblack]

I am running code to produce a list of random numbers.
Once I have generated the random numbers I determine the last row that a number appears in (Which is in column G)
I want to move to the last row of that list and continue running the code

One other thing I need help with is that when my code finishes, there are some Zero numbers in the range named "NumberRange". I want to remove the zeros and just leave the cell empty.

 

[My Aswer Is This]

Show me the code your now using.

I would like to see the code which enters random numbers and also see the code you want to run after the random numbers are entered.

 

[brianfosterblack]

Thanks Yyour comment above made me decide to change my code to

Range("G1000").End(xlUp).Select

this resolved the problem
Thank you for your assistance