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!
Const ResultColumn = "E" 'column for result pasting Dim lRow As Long lRow = Range("A" & Rows.Count).End(xlUp).Row Range(Cells(1, ResultColumn), Cells(lRow, ResultColumn)).FormulaR1C1 = _ "=CONCATENATE(""(A"" & row() & "")="" & RC[-4] )"
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|VBA/SQL - Connect to SQL server and pull data||4||152|
|How to compare ms sql hashbytes results within vb6||5||107|
|Macro to copy formulas to the column direcly to the right and maintain the same range.||2||45|
Join the community of 500,000 technology professionals and ask your questions.