|
|
| Workbook_Activate() vs Workbook_Open() |
| So, when a user opens my Excel file, my Visual Basic script
is going to automatically fill the cells on the current sheet with
predetermined values....
My question is, does it make a difference if I... on 20-Nov-09 |
| |
|
|
|
| simple question regarding pasting |
| I have two columns. BA and BP
BA has data in every row all the way down
BP has data in most of the cells, but some are blank utilizing a
formula of =IF(ISBLANK(BN7),"",BA7 & "," & BN7) Column BP is... on 20-Nov-09 |
| |
|
| The worksheet calculates too often |
| While investigating the performances of a workbook I added a Debug.Print N
inside a function so I can see when the function code runs. N is a static
long that is increased every time. It prints also ... on 20-Nov-09 |
| |
|
| Set Print Area with Dynamic Start Point |
| I want to test a row for a date, for the start cell, for the print area.
Using that cell as a start, select 11 more columns, and 44 rows to set the
print area.
Sub Test1 ()
Range("G17").Select
Do... on 20-Nov-09 |
| |
|
| Calendar Control 8.0 question |
| Is it possible to restrict the date ranges of the Calendar
Control 8.0?? I only want the year 2009 to be selected
from the drop down box.
Thank you! on 20-Nov-09 |
| |
|
| Index-Match and Like...maybe... |
| I originally posted this in the excel functions area, but now I am thinking
it may require some VBA to get it working. I have two lists, one with Stock
Symbol and Sector (Column U and V), the other ... on 20-Nov-09 |
| |
|
|
|