Hi, Hope everybody is fine.
I am using a code to input the same data to the same cell
Code
Private Sub CommandButton1_Click()
Dim names As Range
Set names = Range("J10:J15")
Dim cell As Range
For Each cell In names
cell.Value = cell.Value
Next cell
End Sub
But the problem is I need to expand the range up to J10 to J1000.
When I did the code takes an unexpectedly long time though not all the calls in J10 to J1000 had value.
So can anyone help me how to modify the code only for the cell having value and to work faster.
Thanks and Best Regards.