Change cell text across sheets

Change cell text across sheets

Posted by: dovevim on 27 September 2019, 5:54 pm EST

• 

  dovevim

  • Post Options:
  • Link
    Copy

  Posted 27 September 2019, 5:54 pm EST

  Hi, can i change text for a certain cell in all sheets in spread for winforms or do i have to loop?

• Marked as Answer

  

  mohitg

  

  • Post Options:
  • Link
    Copy

  Replied 29 September 2019, 4:29 pm EST

  Hello,
  
  You can change the particular cell text using the following code:
  FpSpread1.ActiveSheet.Cells(0, 1).Text = "test"
  
  Thanks,
  Mohit