Hi, I am new to macros and vba and have got stuck trying to write a loop, please could someone help with the code?
I want to complete a loop while there's a value (it's a text string) in the first column, starting from row 7 and going down.
I want to put a value in months in column D which is the difference between the dates in columns B and C; if there is no date in B or C for that row, I'd like to leave the 'months' column empty. I know you can use 'DateDiff' but I can't work out how to reference the cells in columns B or C.
Thanks in advance.
Bookmarks