Recent

« previous next »
Pages: [1]

Author Topic: Error or incorrect search parameters  (Read 357 times)

veb86

  • Jr. Member
  • **
  • Posts: 92
Error or incorrect search parameters
« on: February 04, 2025, 09:21:19 am »
I am trying to replace text in the entire sheet. The text is replaced in regular cells, the text specified in the formulas does not change. Is it possible to replace text inside the formulas?
Logged

wp

  • Hero Member
  • *****
  • Posts: 12756
Re: Error or incorrect search parameters
« Reply #1 on: February 04, 2025, 01:22:52 pm »
No, search does not go into the formulas. If you want to rename a worksheet set its Name, and all formulas referring to this sheet are updated.
Logged

veb86

  • Jr. Member
  • **
  • Posts: 92
Re: Error or incorrect search parameters
« Reply #2 on: February 04, 2025, 02:08:42 pm »
Quote from: wp on February 04, 2025, 01:22:52 pm
No, search does not go into the formulas.
I'm rewriting part of the code and I have another solution, but I wanted to make it look nice)))

Quote from: wp on February 04, 2025, 01:22:52 pm
If you want to rename a worksheet set its Name, and all formulas referring to this sheet are updated.
This option is not suitable for my task.
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018