Select tab to import from excel spreadsheet in Macro

  • Follow


I have one excel file that contains multiple tabs.  Is it possible to
select a specific tab to import in a Macro?  I have static labels on
these tabs that can be referenced.  If so, which function would that
be?

Your help is appreciated!

Kanley

0
Reply KT 10/30/2007 6:29:01 PM

Just to clarify, I just need to import one tab at a time, but when i
specify the worksheet name in the range field as WORKSHEET!, it
wouldn't take it.

Please help!

On Oct 30, 11:29 am, KT <kan...@rocketmail.com> wrote:
> I have one excel file that contains multiple tabs.  Is it possible to
> select a specific tab to import in a Macro?  I have static labels on
> these tabs that can be referenced.  If so, which function would that
> be?
>
> Your help is appreciated!
>
> Kanley


0
Reply KT 10/30/2007 9:36:15 PM


1 Replies
301 Views

(page loaded in 0.019 seconds)

Similiar Articles:
















7/15/2012 4:29:14 PM


Reply: