Auto copy range
Posted by Paul on January 10, 2001 9:28 AM
I have an ODBC query that produces a range of results say from A1 to B10 - in C1 and D1 i have formula calcs based on a1 and b1 that I have to constantly copy and paste as the range on requery goes to say a1 to b11. Is there any way of running a macro that dynamically changes to the next cell.
Any help would be gratefully received.
Posted by Mark W. on January 10, 2001 9:47 AM
No need for a macro! Just change your External
Data Range Properties by checking "Fill down formulas
in columns adjacent to data".
Posted by Paul on January 11, 2001 12:53 AM
Mark
Mucho's gracias - never dreamed of looking there
Cheers
