Put variable in another variable

[brainzlp]

I have this variable defined:

Please Login or Register  to view this content.

In a module i came to the end with:

Please Login or Register  to view this content.

Although since i went to this with a .find function, excel thinks NrColIdBDC is a text, how can i make it look for NrColIdBDC.variable

Is there such a function i can put:
PrimeiraColunaSearch = look variable number for PrimeiraColunaSearch

Hope someone can help me, i'm stuck :/

[Richard Buttrey]

Hi,

Just to be clear you haven't created a variable you've created a Constant. Big difference.
Furthermore you've defined the constant to be a string, i.e. text. If you want the Constant to be a number then use

Instead use:

Please Login or Register  to view this content.

[brainzlp]

Still with the same

Gives me problem here:

Please Login or Register  to view this content.

PrimeiraColunaSearch instead of be 1, is "NrColIdBDC"