Extending a selection

G

gwc

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?
 
G

GS

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?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas 2
Expanding Selection 3
How to determine the text selection? 7
PLS HELP ME TO SOLVE THIS PROBLEM 2
Copy and Pasting Formulas 4
Copy reference cell with alternate column 4
Center across selection frustrations 3
sum for date ranges 1

Top