Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OK, Norman,
With your help, I learned more about the Private Sub Worksheet_Activate(). Got it fixed. Program Summary is the main place racers are looked at as a whole. When Im ready, I use the B1 Cell to kick off building this new Race Worksheet. The Race Worksheet is built using the RaceTemplate; a Header and set of 12 rows that make up a 1 race template where I can back changes and maintain that the set of race rows look like. This set of rows are replicated as many times as there are races from the Program Input File. What I was trying to do is carry the balance forward from the previous race. BUT I WAS GOING ABOUT IT WRONG. Thanks to you asking for me about the snipet that called it, I got to thinking why the heck would I not automatically add it during the building of the Betting Sheet. Rather than when I got to it€¦ Kind of like DUH! Oh well€¦ I got it fixed and learned more about the Private Sub Worksheet_Activate() process.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update one worksheet tab to automatically update all other tabs? | Excel Worksheet Functions | |||
Macro to update active workbook in one folder | Excel Worksheet Functions | |||
Update Macro: Leave Colour As Before Once Cell is Not Active | Excel Discussion (Misc queries) | |||
Chart values do not update links to new worksheet | Charts and Charting in Excel | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) |