access vba excel - Excel

Resolved · Low Priority · Version Standard

Thu 19 Jul 2007, 10:01 Delegate William said...

William has attended:
Excel VBA Intro Intermediate course
Excel Advanced course

Excel

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)

Fri 10 Aug 2007, 13:45 Trainer Alan said...

RE: Excel

Hi William

The answer is NO.

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

Alan

VBA tip:

Stuck in a Code Loop

If you ever get stuck in an infinite code loop when programing in VBA use

CTRL+BREAK

to exit the procedure

View all VBA hints and tips

access vba excel - Excel

Excel

RE: Excel

VBA articles

VBA tip:

Stuck in a Code Loop