MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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