dynamic auto fill

[chinster99]

Hi,

I have a report that is connected to an external data source. One of the columns is a function that converts a number stored in the database to a recognised date format.

So what I am looking for is a method in VBA to see the range of the data after the refresh, and autofill the function column to the end of the range.

Thanks

Leo

 

[xlbo]

If you are using Data>Get External Data, one of the options is to autofill formulae next to the data range. check that and you should be away. Note tho that only formulae to the RIGHT of the data area are included in this (unfortunately)

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[chinster99]

Geoff,

Thanks for that, it works perfectly. i didn't know that was an option.