szakharov7723
Board Regular
- Joined
- Jun 22, 2018
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
So generally I am trying to make my text formula work, but as many other methods, this one doesn't work for some reason.
This formula is text form, hence it doesn't work, until you change something within it.
So this code works fine for everything, but my formula. It works fine with making basic text reference formula into real one, it works fine with changing signs like =,+,- e.t.c
Code:
=IFERROR('K:\PLANING\Apr\[Thu, Apr 11.xlsb]Millright data'!B7+'K:\PLANING\Apr\[Thu, Apr 11_2.xlsb]Millright data'!B7,'K:\PLANING\Apr\[Thu, Apr 11.xlsb]Millright data'!B7
Code:
Private Sub CommandButton1_Click()
Dim i As Integer
i = 97
Do Until i > 374
Cells(i, 3).Replace What:="=", Replacement:="="
i = i + 1
Loop
End Sub
So this code works fine for everything, but my formula. It works fine with making basic text reference formula into real one, it works fine with changing signs like =,+,- e.t.c