<div>
Right, I know this but is there a way to make a selected range the top left cell in focus?<br />

</div>


Right, I know this but is there a way to make a selected range the top left cell in focus?


<div>
Sub TryThis()<br />
&nbsp; &nbsp;'Replace ActiveSheet by the appropriate worksheet<br />
&nbsp; &nbsp;Application.Goto reference:=ActiveSheet.Ran<wbr />ge(&quot;c5:e10<wbr />&quot;), Scroll:=True<br />
End Sub
</div>


Sub TryThis()
   'Replace ActiveSheet by the appropriate worksheet
   Application.Goto reference:=ActiveSheet.Range("c5:e10"), Scroll:=True
End Sub

<div>
Thanks cri. Yeah I discovered this yesterday (with the aid of an amateur at the office) I must have been having a brainstorm, it never occurred to me to record a macro with F5 (find range)Dumb or wot<br />
<br />
macbone2
</div>


Thanks cri. Yeah I discovered this yesterday (with the aid of an amateur at the office) I must have been having a brainstorm, it never occurred to me to record a macro with F5 (find range)Dumb or wot

macbone2

<div>
<div class="content wysiwyg-content">
how can I select a given &nbsp;cell location<br />
<br />
e.g: WC2000 <br />
<br />
<br />
thanks<br />
&nbsp;
</div>
</div>


how can I select a given  cell location

e.g: WC2000 


thanks
 

Browse to given cell location

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.