Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The * in the If statement is confusing me, is it the same as And, OR, or Either as it relates to the rngC.Value
What exact does the If statement say? In my test to try to understand the statement I kept getting Type mismatch errors. Using A1 and B1 then pulling down to produce a small data set to apply the code to, and using = or < "xx" instead of 99. Using numbers only seems to prevent that. The col 46 = col 49 I understand. Thanks. Howard Private Sub Worksheet_Calculate() Dim LRow As Long Dim rngC As Range LRow = Cells(Rows.Count, 61).End(xlUp).Row For Each rngC In Range("BI1:BI" & LRow) If rngC.Value * rngC.Offset(, 1).Value = 99 Then Cells(rngC.Row, 46) = Cells(rngC.Row, 49) End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZ HELP !! ) | Excel Discussion (Misc queries) | |||
Code jumps to WS_Calculate on a different sheet | Excel Programming | |||
How to replace the background color of all cells from light green to light blue? | Excel Programming | |||
How to replace the background color of all cells from light green to light blue? | Excel Discussion (Misc queries) | |||
Macro help (not the sharpest tool in the shed) | Excel Programming |