Qlikview - excel file center specific character

[#1]

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?