dboyd616
07-27-2015, 02:49 PM
I’m looking to figure out an automation process for an excel file I have, using VBA code. I’m fairly new to VBA coding, and my last few attempts have been unsuccessful. I was hoping I could possibly find some guidance on the subject?
There are multiple sheets within the excel file, but all work will be done via the ‘Activesheet’ for ease of use. There are over 800 rows that this code would have to run through, so it needs to be some sort of loop.
Please help if possible, and let me know if I need to provide any more information for a proper diagnosis. Thanks!
Example of structure (in my mind):
If Column A contains “TextA” Then _
Column D will contain “TextA”
ElseIf Column A contains “Text B” Then _
Column D will contain “Text C”
ElseIf Column A contains Nothing Then_
Column A will now contain “Null” in Bold Red font
Else
End If
Next Loop (next row)
End Sub
There are multiple sheets within the excel file, but all work will be done via the ‘Activesheet’ for ease of use. There are over 800 rows that this code would have to run through, so it needs to be some sort of loop.
Please help if possible, and let me know if I need to provide any more information for a proper diagnosis. Thanks!
Example of structure (in my mind):
If Column A contains “TextA” Then _
Column D will contain “TextA”
ElseIf Column A contains “Text B” Then _
Column D will contain “Text C”
ElseIf Column A contains Nothing Then_
Column A will now contain “Null” in Bold Red font
Else
End If
Next Loop (next row)
End Sub