willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
Hello,
I am looking to clean up some data in another Macro I have and am trying to figure out the code for one part of the clean up.
Basically in column C there are ship dates and in column B there are due dates. When there is a blank cell in column C I want it to bring over the value from column B.
The below code I have is giving me an error so I am missing something...
Any help would be appreciated.
Thank you!
I am looking to clean up some data in another Macro I have and am trying to figure out the code for one part of the clean up.
Basically in column C there are ship dates and in column B there are due dates. When there is a blank cell in column C I want it to bring over the value from column B.
The below code I have is giving me an error so I am missing something...
VBA Code:
Dim rCell As Range
For Each rCell In Range("C2:C")
If rCell.Value = "" Then
rCell.Formula = "=[@[Due Date]]"
rCell.Value = rCell.Value
End If
Next rCell
Any help would be appreciated.
Thank you!