I have this variable defined:
In a module i came to the end with:
'Número da coluna ID Cliente Public Const NrColIdBDC As String = 1
Although since i went to this with a .find function, excel thinks NrColIdBDC is a text, how can i make it look for NrColIdBDC.variablePrimeiraColunaSearch = NrColIdBDC
Is there such a function i can put:
PrimeiraColunaSearch = look variable number for PrimeiraColunaSearch
Hope someone can help me, i'm stuck :/
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:
Public Const NrColIdBDC As Long = 1
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Still with the same
Gives me problem here:
PrimeiraColunaSearch instead of be 1, is "NrColIdBDC"BasedeDados.Range(ColunasQuadroBDC).AutoFilter Field:=PrimeiraColunaSearch, Criteria1:="=" & FiltroPrimeiraColuna
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks