alancardoso
Board Regular
- Joined
- Nov 9, 2004
- Messages
- 85
What I´m trying to do is to concatenate a few cells, creating a text string.
Then, I want to convert this string to a formula.
As I will be using this code for a lot of cells, I´ve decided do create a User Defined Function.
The problem that I´m having is that as far as I know there is no equivalent do the Indirect Excel function, and there is no way to access this function from VBA
Thanks!
Alan
Then, I want to convert this string to a formula.
As I will be using this code for a lot of cells, I´ve decided do create a User Defined Function.
The problem that I´m having is that as far as I know there is no equivalent do the Indirect Excel function, and there is no way to access this function from VBA
Code:
Function Facil(Arquivo As String, Planilha As String, Célula As String)
Application.Volatile
Dim Texto
Texto = Arquivo & Planilha & Célula
Facil =
Thanks!
Alan