Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why does it matter where you put the "=" in a macro (see line 3). I am range
valuing cells that contain the "If" formula. In the following code: For Each cll In Range("v10:v44") If Left(cll.Formula, 3) = "=IF" Then cll.Value = cll End If Next why does this range value my cells but this next code does not: For Each cll In Range("v10:v44") If Left(cll.Formula, 3) = "=IF" Then cll = cll.Value End If Next Why is cll.Value=cll not the same as cll=cll.Value Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forms Positioning | Excel Discussion (Misc queries) | |||
POSITIONING A TOOLBAR | Excel Discussion (Misc queries) | |||
Comment Box Positioning Q | Excel Worksheet Functions | |||
AutoShape Positioning? | Excel Discussion (Misc queries) | |||
msgbox positioning | Excel Programming |