jaystang
09-20-2018, 04:28 PM
Hello, I've inherited an Excel macro at work that I need to update. I am somewhat familiar with VBA but far from being an expert. Here is a snippet of the code I would like to ask about:
If Len(bad_data_temp) = 0 Then
bad_data_temp = arr1(i, 1) & " in row " & i & "[at sign][at sign][at sign][at sign][at sign]Range(" & column_number & i
End If
I don't understand what the Range and column_number is doing. What is the purpose of the "[at sign]" and why are there 5 of them? What is the "(" at the end of the Range doing? I tried Google but I couldn't find any information about this. Thanks for any help you can provide.
The code actually contains the "at sign" but the forum won't let me post it.
If Len(bad_data_temp) = 0 Then
bad_data_temp = arr1(i, 1) & " in row " & i & "[at sign][at sign][at sign][at sign][at sign]Range(" & column_number & i
End If
I don't understand what the Range and column_number is doing. What is the purpose of the "[at sign]" and why are there 5 of them? What is the "(" at the end of the Range doing? I tried Google but I couldn't find any information about this. Thanks for any help you can provide.
The code actually contains the "at sign" but the forum won't let me post it.