Posts by JimFuller1

Re: Refer to Sheet by Secret Name

Beautiful. That works. I don't want to push my luck but, is there a way to combine the activate and clear lines?

Thanks a million,
Jim

Re: Refer to Sheet by Secret Name

It still hangs at the paste command.

Workbooks(sTrafficFileName).Activate
    sOrdersFB.Cells.Clear
    Workbooks(sBobName).Sheets("Orders").Cells.Copy
    Workbooks(sTrafficFileName).Activate
    sOrdersFB.Paste ("A1")

Jim

Re: Refer to Sheet by Secret Name

OK. The select works but now I can't paste.

sOrdersFB.Cells.Clear
Workbooks(sBobName).Sheets("Orders").Cells.Copy
Workbooks(sTrafficFileName).Activate
sOrdersFB.Range("a1").Paste

Thanks again,
Jim

Re: Refer to Sheet by Secret Name

OK. The select works but now I can't paste.

[code] sOrdersFB.Cells.Clear
Workbooks(sBobName).Sheets("Orders").Cells.Copy
Workbooks(sTrafficFileName).Activate
sOrdersFB.Range("a1").Paste
[\code]

Re: Refer to Sheet by Secret Name

This doesn't work:

sOrdersFB.Range("A1").Select

What next?

Jim

When I look in VBA under the Microsoft Excel Objects at the sheet names in my workbook I see two names for the same sheet like so:

sOrdersFB(Orders From Bob)

Can someone tell me how to select using the first name sOrdersFB?