Found out the reason.. it is a merge cell only during the beginning of each occurrence. Is there a way to unmerge all cells in a column F within that macro too?
Thanks for your time
Found out the reason.. it is a merge cell only during the beginning of each occurrence. Is there a way to unmerge all cells in a column F within that macro too?
Thanks for your time
found it.. thanks once again for all your help.. [a1:d10000].UnMerge