Hi all,
I have next macro code to center character in excel file
XLSheet.Range("AJ16:AT16").HorizontalAlignment = xlCenter
XLSheet.Range("AJ16:AT16").VerticalAlignment = xlCenter
but put in center every character in this range...
I want to put in center only character 'I'.
how to make something like this
if(XLSheet.Range("AJ16:AT16") contains I) then
XLSheet.Range("AJ16:AT16").HorizontalAlignment = xlCenter
XLSheet.Range("AJ16:AT16").VerticalAlignment = xlCenter
end if
Any idea?