but this doesn't seem to do anything. Once I have managed to select the second cell, I am not entirely sure how to merge the two. I think the code below is what I would use:
With oSheet.Range("A1:" & Chr(iNumCols + 64) & rs.RecordCount + 1) For Each C In oSheet.Range("A1:" & Chr(iNumCols + 64) & rs.RecordCount + 1).Cells If C.Value = "Words in the cell" Then With C .Font.Name = "Arial" .Font.Bold = True .Font.Size = 12
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!