VB in Excel -copying a formula down

[DanAuber]

When in Excel - if you are in a certain cell, and you double click in the right hand lower corner of the cell(when you get a black cross) - it copies the formula in the cell down until it gets to a blank cell in the columns either side.

This is very useful functionality - is there an Excel VBA macro command I can use to get this to happen within my macro ?

Thanks for any help

Dan

 

[SkipVought]

Hi,

You have to define the range and use PasteSpecial - Formulas...

Range1.Copy
Range2.PasteSpecial xlFormulas

Check out the End range method, CurrentRegion, UsedRange. It all depends on the geometry of your data area -- is your data area contiguous, etc?



Skip,

_[red][/red]

 

[PHV]

Have a look at the AutoFill method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DanAuber]

Thanks Guys