Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
Sub FillNum() Dim myRange As Range Set myRange = Cells.Find(What:="*", after:=[Q2], SearchOrder:=xlByRows, SearchDirection:=xlPrevious) Set myRange = Range(Cells(3, 1), Cells(myRange.Row, 1)) With myRange .NumberFormat = "General" .FormulaR1C1 = "=""0000""&ROW()-2" .NumberFormat = "@" .Value = .Value End With End Sub
|Out of stack space (Error 28)||5||24|
|In Excel 2007, how do I insert a blank space between two dynamic values in a cell?||3||10|
|Excel Array formula issues||4||13|
|EXCEL formula help required||3||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!