Page numbers

[Ian Mac]

All,

Is there a way of countins the number of sheets that have a certain name on a assigning a Page (Sheet) number to a particular cell on each.

i.e. I have 12 sheets (current) they are all called AgentA Mon, AgentB Mon, AgentC Mon etc. (the AgentA,b,c are real names of people). This is repeated for each day of the week.
What I'd like is for Excel to count the number of sheets and on AgentA put A1= "page 1" B1= "of 12".
the cells don't actually NEED the 'page' or 'of' in them.

I'd like this to be done viewing the sheets left to right in the workbook.

Also, if it's any help every day had the SAME people and ALWAY the same order.

Anyone??

 

[Jay Petrulis]

Hi Ian,

Application.CalculateFull

is the VBA equivalent of Ctrl+Alt+F9.

Regards,
Jay

 

[Ian Mac]

Excellent! Thanks for that.

 

[Ian Mac]

On 2002-04-05 05:55, Jay Petrulis wrote:
Hi Ian,

Application.CalculateFull

is the VBA equivalent of Ctrl+Alt+F9.

Regards,
Jay

Sorry I was a bit hasty, I don't have the option for CalculateFull only Calculate.

 

[codger]

Err, sorry, VBA is not part of my expertise (hence why I'll go to any lengths to work in Excel)

But I'm pretty sure that XL97 VBA doesn't have a ctrl+alt+F9 equivalent. Short of Application.SendKeys of course.

 

[Jay Petrulis]

Major apologies. I have Excel 2000 at home and Excel 97 at work. Excel 97 doesn't have the .CalculateFull

Try,

SendKeys "%^{F9}", True

for Excel 97.

Bye,
Jay

 

[Ian Mac]

On 2002-04-05 08:37, Jay Petrulis wrote:
Major apologies. I have Excel 2000 at home and Excel 97 at work. Excel 97 doesn't have the .CalculateFull

Try,

SendKeys "%^{F9}", True

Thanks works a treat, I also have 2000 and xp at home and 97 at work, ITS BEEN A LOT OF YEARS SINCE 97 HAS MY COMPANY NOT MADE THE PROFIT NEEDED TO UPGRADE!
for Excel 97.

Bye,
Jay

 

[withit45]

i want my workbook to have more then 3 sheets but i can't find how or where to change that at

 

[InTurn123]

withit45,

Insert>Worksheet. That's it.