Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
' 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.
|copy selected cell into new worksheet using checkbox||15||57|
|VBA Kill file but send it to recycle bin, Not permanently delete it.||26||42|
|Excel Macro: Correct Macro that creates tabs for each "AccountSku"||4||47|
|Format Control on two Buttons||6||22|
Join the community of 500,000 technology professionals and ask your questions.