VBA If Statement

[rlsublime]

I am trying to get the following IF Statement to work in VBA. I want it to paste a value in the D cells if the D cell is empty and the C cells are not empty. Thanks in advance for the help.

If Range("C:C") Is Not Null And Range("D:D") Is Null Then Range("D:D") = Range("A2").Value

[Jakobshavn]

How about:

Please Login or Register  to view this content.

[rlsublime]

this did not fill the cells with A2. I used the code above. Any thoughts?

[Jakobshavn]

Here is my test of the macro

[rlsublime]

i am trying to get it to only paste in d6 since there is a value in c6. currently, it is filling in the entire D column. Also, if there is a value in both c and D i want it to skip that value and move to the next. Thanks

[Jakobshavn]

Then how about:

Please Login or Register  to view this content.

[rlsublime]

I was getting an Error 424:Object Required and it was highlighting "For Each dd In D"

[Jakobshavn]

I will check.

[rlsublime]

It worked with the following:. What I am trying to do on another sheet is to say is D:D contains a date with format mm/dd/yyyy, then format the respective cell in C:C with a date format also.

Please Login or Register  to view this content.