Denblanc
03-15-2016, 05:16 PM
Hello everyone,
I hope this is something simple to fix. My VBA code inserts a formula into Column "D" to combine Columns "C & D" that is separated by a comma. The problem is when the content ends (number of rows varies) commas are inserted in the blank rows until the great beyond.
Range("D4:D" & .Range("D" & .Rows.Count).End(xlDown).row).Formula = "=(C4&"", ""&B4)"
Any suggestions on whether to delete the rows or what to insert to stop at end of content?
Thanks for your help!
I hope this is something simple to fix. My VBA code inserts a formula into Column "D" to combine Columns "C & D" that is separated by a comma. The problem is when the content ends (number of rows varies) commas are inserted in the blank rows until the great beyond.
Range("D4:D" & .Range("D" & .Rows.Count).End(xlDown).row).Formula = "=(C4&"", ""&B4)"
Any suggestions on whether to delete the rows or what to insert to stop at end of content?
Thanks for your help!