i’m trying to use a cell as a row value on filter activity.
The value on Cell Q2 is the number for the row on the Range(B24:M(row number)
but i cant seem to find a solution for this, i’m geting a complier error.
code i tryed to use as last atempt
Dim tamanho As String _
tamanho = Excel.Sheet"3. CONT RD 3800").Range (“Q2”)_
Excel.Sheet(“3. CONT RD 3800”).Range (“B24:M”+tamanho.ToString))