[Dba-office] Excel sheet tabs & reference to it

David McAfee davidmcafee at gmail.com
Thu May 10 01:22:55 CDT 2018


Im half asleep right now, and dont have a computer in front of me, but i do
know i have referenced worksheets by number instrad of name.

It was something like WB.Sheet(1) or something lime that. I'll take a look
when i get into the office if nobody has chimed in.

On Wed, May 9, 2018, 10:20 PM John Bartow <jbartow at winhaven.net> wrote:

> I have a baseball roster, player stats and team stats. Each player gets a
> sheet with all of their stats per game. That sheet has the players name as
> the sheet tab name.
>
> At the end of each season all I have to do is type in the new player
> roster and everything works. Except the Tab names and because the sheets
> are references for the team totals, the tab names are in the totals
> function's reference.
>
> Is there some method of finding and replacing a word in the entire
> workbook - including the name of the sheet tabs?
>
> Or is there a method to reference the tab without using the tab's name?
>
> Thanks,
> John B
>
> _______________________________________________
> Dba-office mailing list
> Dba-office at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-office
>


More information about the Dba-office mailing list