access vba excel - Excel

The UK's most regular instructor-led training courses.
Training information: access vba excel · Excel london

Resolved · Low Priority · Version Standard

Excel

William has attended:
Excel VBA course
Excel Advanced course

by - delegate William [3 posts] (2007 Jul 19 Thu, 10:01) Reply

Is there any easy way of writing a formula in a cell that is linked to a number of other spreadsheets so that when changes are made to the data in that reference cell (because information affecting that cell changes) these changes are only reflected in the worksheets with a date on or after the date the changes are made? (i.e. not worksheets with a date prior to the date the changes are made)

RE: Excel

by - trainer Alan silver contributer [59 posts] (2007 Aug 10 Fri, 13:45) Reply

Hi William

The answer is NO.

You would have to use code which utilised the worksheet properties to check date modified fields.

Alan

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips