msvisual.com Forum Index
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to refer to an excell sheet name by reference to a cell.

 
Post new topic   Reply to topic    msvisual.com Forum Index -> DirectX
Author Message
Frank The Novice



Joined: 04 Oct 2007
Posts: 1

PostPosted: Mon Sep 03, 2007 2:50 pm    Post subject: How to refer to an excell sheet name by reference to a cell. Reply with quote

Hello All,

I have a workbook, that has 25 worksheets. One sheet is an input sheet that
collects the data for the other sheets, that are named either "Daily" or
"Monthly", and then the Month an year.

I would like to have the macro automatically detect which sheet to copy the
data to, by having the "sheets("nnnnn").Select" command refer to a cell in
the input sheet.

Can anyone help me with a solution???

Thank you so much,

Frank

Archived from group: microsoft>public>vb>directx
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    msvisual.com Forum Index -> DirectX All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group