C
Craig Brandt
I have a procedure that sets up a bunch of querys and then uses the data in
the first query to parse out the dates. If I breakpoint the operations
following the querys and wait until they have finished, all works properly.
But if I pull the breakpoint so the procedure places formulas into the sheet
that uses the query data, it puts some of the subsequent formulas in the
wrong cells.
Setup querys
place formula in A1 to count the resulting number of elements produced by
the query
populate A3 with a formula to parse data from the first column of data
Autofill column A using A1 to determine how far down to go
The autofill uses A1 before it has time to caluclate the number of entries
and the autofill overwrites A1:A3
Is the a wait-to-proceed method in VBA so I can avoid this?
Craig
the first query to parse out the dates. If I breakpoint the operations
following the querys and wait until they have finished, all works properly.
But if I pull the breakpoint so the procedure places formulas into the sheet
that uses the query data, it puts some of the subsequent formulas in the
wrong cells.
Setup querys
place formula in A1 to count the resulting number of elements produced by
the query
populate A3 with a formula to parse data from the first column of data
Autofill column A using A1 to determine how far down to go
The autofill uses A1 before it has time to caluclate the number of entries
and the autofill overwrites A1:A3
Is the a wait-to-proceed method in VBA so I can avoid this?
Craig