We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
' Find Monthly plan range titled with "Planned Dollars Cells.Find(What:="Planned Dollars", After:=ActiveCell, LookIn:=xlFormulas _ , LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate ' Move to cell in Row with Month title ActiveCell.Offset(1, 0).Select '***Need to select Currrent Cell and 11 more on right Range(ActiveCell, "Z2").Select For Each Cell In Selection If Cell.Value = CurMo Then '** I need to select the column that has the matched value*************** '** This currently finds a match to Aug but the active cell is still O2 '**Does not work "Range(ActiveCell).Select" Range(ActiveCell, ActiveCell.End(xlDown)).Select Exit For End If Next Cell ' Copy Values in column as Current Moth Planned dollars Selection.Copy Windows("GTFPTemplate.xls").Activate Range("T7").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Windows("2011 U.S. Financial Plan.xls").Activate
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.