| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference range in formula problem
How do I indicate a cell value at other range?
I try something =IF(H17=27759,range("K7") = "yes",range("K7") ="no") but the activecell give #name! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference range in formula problem
A worksheet formula cannot change the value of any other cell. It
can only return a value to the cell which contains the formula. In cell K7, use the formula =IF(H17=27759,"yes","no") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "crapit" wrote in message ... How do I indicate a cell value at other range? I try something =IF(H17=27759,range("K7") = "yes",range("K7") ="no") but the activecell give #name! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference range in formula problem
So the only is through macro?
"Chip Pearson" wrote in message ... A worksheet formula cannot change the value of any other cell. It can only return a value to the cell which contains the formula. In cell K7, use the formula =IF(H17=27759,"yes","no") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "crapit" wrote in message ... How do I indicate a cell value at other range? I try something =IF(H17=27759,range("K7") = "yes",range("K7") ="no") but the activecell give #name! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference range in formula problem
Yes, a macro can do it, as long as it is not called from a
worksheet cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "crapit" wrote in message ... So the only is through macro? "Chip Pearson" wrote in message ... A worksheet formula cannot change the value of any other cell. It can only return a value to the cell which contains the formula. In cell K7, use the formula =IF(H17=27759,"yes","no") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "crapit" wrote in message ... How do I indicate a cell value at other range? I try something =IF(H17=27759,range("K7") = "yes",range("K7") ="no") but the activecell give #name! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference range in formula problem
I tried the following but it doesnt work. both H17 & J17 are individually
merge cells Private Sub Worksheet_Change(ByVal Target As Range) If Range("h17").Value = 123 Then Range("j17").Value = Allocation end if end sub "Chip Pearson" wrote in message ... Yes, a macro can do it, as long as it is not called from a worksheet cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "crapit" wrote in message ... So the only is through macro? "Chip Pearson" wrote in message ... A worksheet formula cannot change the value of any other cell. It can only return a value to the cell which contains the formula. In cell K7, use the formula =IF(H17=27759,"yes","no") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "crapit" wrote in message ... How do I indicate a cell value at other range? I try something =IF(H17=27759,range("K7") = "yes",range("K7") ="no") but the activecell give #name! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative Range Reference in a sumifs formula | Excel Worksheet Functions | |||
| Cell reference formula problem | Excel Discussion (Misc queries) | |||
| Cell reference in formula as range | Excel Discussion (Misc queries) | |||
| Named Formula reference problem | Excel Worksheet Functions | |||
| using a dummy cell to reference a range into a formula | Excel Discussion (Misc queries) | |||
Linear Mode
