Hello,

Say I have this command in a sheet's VB code:

Sheets("Sheet1").Range("A1").Select

Now instead of referencing Sheet1 in the current workbook, I want to
reference Sheet1 in OtherWorkbook.xls.

How can I make this work? Any help would be greatly appreciated! =)

-Mike

Mike

You could do something like this...

Dim wbOther as workbook
Set wbOther = Workbooks.Open( "C:\YourPath\OtherWorkbook.xls")
wbOther.Sheets("Sheet1").Range("A1").Select

If it's open then just

Workbooks("OtherWorkbook").Sheets(......

Will suffice

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/


wrote in message
news:(E-Mail Removed)...
> Hello,
>
> Say I have this command in a sheet's VB code:
>
> Sheets("Sheet1").Range("A1").Select
>
> Now instead of referencing Sheet1 in the current workbook, I want to
> reference Sheet1 in OtherWorkbook.xls.
>
> How can I make this work? Any help would be greatly appreciated! =)
>
> -Mike
>

Just a note about selecting a range. The sheet has to be active and the
workbook has to be active.

wbOther.Sheets("Sheet1").Range("A1").Select

could be:

wbOther.activate
wbOther.Sheets("Sheet1").select
wbOther.Sheets("Sheet1").Range("A1").Select

or
application.goto wbOther.Sheets("Sheet1").Range("A1"), scroll:=true '??



Nick Hodge wrote:
>
> Mike
>
> You could do something like this...
>
> Dim wbOther as workbook
> Set wbOther = Workbooks.Open( "C:\YourPath\OtherWorkbook.xls")
> wbOther.Sheets("Sheet1").Range("A1").Select
>
> If it's open then just
>
> Workbooks("OtherWorkbook").Sheets(......
>
> Will suffice
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> (E-Mail Removed)DTHIS
> web: www.nickhodge.co.uk
> blog (non-tech): www.nickhodge.co.uk/blog/
>
> wrote in message
> news:(E-Mail Removed)...
> > Hello,
> >
> > Say I have this command in a sheet's VB code:
> >
> > Sheets("Sheet1").Range("A1").Select
> >
> > Now instead of referencing Sheet1 in the current workbook, I want to
> > reference Sheet1 in OtherWorkbook.xls.
> >
> > How can I make this work? Any help would be greatly appreciated! =)
> >
> > -Mike
> >

--

Dave Peterson

Awesome, that did the trick! Thanks for the help Nick and Dave.

-Mike

Glad it worked Mike

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

wrote in message
news:(E-Mail Removed)...
> Awesome, that did the trick! Thanks for the help Nick and Dave.
>
> -Mike
>