Copy then content of one cell and pasting in another 1

[apeoortje]

I've written an Excel sheet that displays the begin and end date of each week in the current month. unfortunaty these result are almost ramdomly placed in a collum, and are of little use as I still have to put in the information in a cells I want it in by hand.

does anyone know if there is a macro that can be written which, if the cells has any information it copy pastes it in another unless the cells has information in it.

I tried myself but I couldn't get it. All that happened was the Macro got stuck in a loop and crashed.

PLEASE HELP!!!!

 

[PHV]

Something like this ?
If Len(Range("C3")) = 0 Then
Range("A1").Copy Range("C3")
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[apeoortje]

That's that one I was looking for.

Thank you VERY much!!! You can put a gold star of you monitor now!!!! LOL

 

[ETID]

...How bout a purple one instead!!!