Thread: FormulaR1C1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marc[_26_] Marc[_26_] is offline
external usenet poster
 
Posts: 14
Default FormulaR1C1

I have vfp code like below
loExcelSession.Cells(1,11).FormulaR1C1 =
ALLTRIM(STR(loExcelSession.Cells(1,11).Value))
Is there anyway to update the entire column at once?