Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with leap-frogging myCell Range
2003
Here is what I am trying to do the (code below is not all of the code - just enough for explanation): For Each myCell in myRange Sheets("Constants Input").Autofilter If Sheets("Constants Input").AutoFilterMode = True Then Sheets("Constants Input").UsedRange.AutoFilter End If FilterCriteria = 33 With Sheets("Constants Input").Range("A1:F" & Cells(Rows.Count, _ "B").End(xlUp).Row) .AutoFilter Field:=2, Criteria1:="<" .AutoFilter Field:=4, Criteria1:="=" & FilterCriteria End With myCell.Offset(0, 3).Formula = Sheets("Constants Input").Range("E2:E" _ & Cells(Rows.Count, "E").End(xlUp).Row).SpecialCells(xlVisible) _ .Cells(2, 5).Formula 'First time through the loop ... Cells(2, 5) returns the formula in '"E2" which is fine. But each succeeding myCell the address is "I2" ' Next Mycell I am now Too Close to the Problem to see something really obvious. What I need is for every formula in Range("E2:E" & VisibleCells.Rows.count) to have exactly the same formula as in the first visible cell in Column "E" after the FilterCriteria is changed for each myCell "D2:Dxxxxx" TIA EagleOne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leap year problem. | Excel Discussion (Misc queries) | |||
ListBox1. add item myCell.entirerow | Excel Discussion (Misc queries) | |||
Is Leap Day between Date Range? | Excel Worksheet Functions | |||
Leap year date problem | Excel Worksheet Functions | |||
Value of next visible mycell within a rng | Excel Programming |