Extending a selection
 

How can I copy a formula in C1 and paste the formula in C1 thru Cxxxxxxx where 'xxxxxxx' is the last cell in column B that contains data?

Extending a selection
 

gwc formulated on Monday :
How can I copy a formula in C1 and paste the formula in C1 thru Cxxxxxxx
where 'xxxxxxx' is the last cell in column B that contains data?

Select C1 thru Cxxxxxxx
Enter the formula
Press 'Enter' while holding down the 'Ctrl' key

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion