Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
' 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
|I need help with an EXCEL Nested formula.||5||24|
|VBA - Transfer values from Master wb to all wbs. Delete old data, copy new data from master wb to user wbs located in a folder.||3||18|
|Copy cell contents for two columns and put into a comment for a cell in another column||6||17|
|Using SUMPRODUCT with a Date Range||6||19|