- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- cant write a formula in some cells

Subject: | cant write a formula in some cells |

Posted by: | Kevin (kevin.brenn…@worldnet.att.com.RemoveMe!) |

Date: | Mon, 27 Oct 2003 |

This is a two part question, first, I have a value that I want to copy all

the way from range B3:B6000, what I do is just write a formula in B4 as =B3

and then select B4 and drag the mouse with the autofill all the way to the

cell B6000! Is there a simpler, elegant way to copy the value of B3 form

B4:B6000?

Second question, when I write the formula in B4 or anywhere in the B:B range

the formula is not a formula???. I look to see if there is a macro that does

not allow to write a formula in that range but cant find any reference to

Column B in that Sheet. I check many thing and all I can think are, the page

or workbook are not protected, cant find any reference in Sheet 1 that

contains a macro on range B:B, I also tried to trace de formula but excel

said its not a formula, Does anybody has any Ideas!

Thanks in advance.

Kevin Brenner

- Re: cant write a formula in some cells posted by Tom Ogilvy on Sun, 26 Oct 2003