Copy Adjacent Cell

Hello, I'm trying to write a program where my macro will look for null values and replace the null values with the adjacent cell's value to the right. However, I have the syntax wrong and I would greatly appreciate your help in the matter.

Please Login or Register  to view this content.

Thanks

Hello rbirch,

You don't need to use copy unless the destination cell needs the same formatting.

Please Login or Register  to view this content.