make x as variable

[rplim2016]

Hello Excel Gurus,

Simple question: is it possible to make x variable using the function above? or anything text or numbers that I want to declare.

not working code

Option Explicit


Sub test()
Dim x As String
Debug.Print Evaluate("=CELL(""format"",x)")
End Sub

working code

Option Explicit


Sub test()
Dim x As String
Debug.Print Evaluate("=CELL(""format"",A2)")
End Sub


Thanks!

 

[rplim2016]

Hello users,

I just figured it out. lol

Option Explicit


Sub test()
Dim X As String


X = "A2"
Debug.Print Evaluate("=CELL(""format""," & X & ")")
End Sub

Thanks

 

[silentwolf]

Hi,
If you are using a varible then you need to fill that variable with a value.

Dim x as string

x = "My String"

But if you are using a string varible you should might consider to name the varible a little better. x, i, j, and so on are mostly used as integer varibles for loops better would be strMyText as string or something like that.
So basically what I am saying is when you declare a varible then specify the datatyp at the beginnen then if you get a runtime error you can spot the wrong declared varible a bit better.
Just a thought

 

[MARK858]

You haven't made your variable equal anything, it needs to be a cell reference.

Sub test()
Dim x As String
[COLOR="#FF0000"]x = Cells(2, "A").Address(0, 0)[/COLOR]
Debug.Print Evaluate("=CELL(""format"",[COLOR="#FF0000"]" & x & "[/COLOR])")
End Sub

 

[MARK858]

Hmm, duplicate thread of

https://www.mrexcel.com/forum/excel-questions/1091879-make-x-variable.html

 

[Macropod]

Threads merged.