Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).
' 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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!