rhk001
04-21-2009, 01:23 PM
Hi Guys,
Can anyone help me with this question please. I have some two sets of dates, Start dates in Column C, Finish Dates in Column D. I want to loop through Column D and where it is blank, repalce the balnk with the value in column C. (The data gets imported into Excel so amount of data / rows can vary)
I have done this using the If function, bit would like to do it using VBA. The function is simply =IF(C2="",D2,C2)
Thanks:doh:
Can anyone help me with this question please. I have some two sets of dates, Start dates in Column C, Finish Dates in Column D. I want to loop through Column D and where it is blank, repalce the balnk with the value in column C. (The data gets imported into Excel so amount of data / rows can vary)
I have done this using the If function, bit would like to do it using VBA. The function is simply =IF(C2="",D2,C2)
Thanks:doh: