First give the range a name.

InsertNameDefine myrng

Private Sub CommandButton1_Click()
Application.Goto Reference:="myrng"
End Sub


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 00:41:01 -0700, Johanna Gronlund
wrote:

Hello,

I have a command button (Button 4585). I would like it to take the user to
another place (cells A147:A180) on the same sheet (Sheet 10). Is this
possible? I cannot just use a hyperlink on a cell as the button only becomes
visible if the user makes certain choices.

Thanks very much in advance.

Johanna