Macro Question

[Ramone]

Hello All,

Could some please tell me how to write a macro that will
past the data from cell 1A into cell C10 if C10 is blank
and past the date in C11 if C10 is not blank.


Thanks for any help

 

[bj]

sub XX()
if cells(10,3)="" then cells(10,3)=cells(1,1) else cells
(11,3)=cells(1,1)
end sub

 

[Ramone]

Thanks for the reply

-----Original Message-----
sub XX()
if cells(10,3)="" then cells(10,3)=cells(1,1) else cells
(11,3)=cells(1,1)
end sub
.