View original (French)

Assign cell content to variable

Dolichotis Posted messages 42 Registration date   Status Membre Last intervention   -  
Polux31 Posted messages 7219 Status Membre -
Hello,

In VBA (Excel 2003), I am trying to assign the content of a cell to a variable. I tried it like this: 

 Dim Type As String Type = wsExcel.Range("L" & Lig).Value


but it's not working!
If you have any solutions to propose, thank you! 

Configuration: Windows 2000 Firefox 2.0.0.14

7 réponses

Réponse 1 / 7
Polux31 Posted messages 7219 Status Membre 1 204
 
Hello,

What does wsExcel represent? And Type is a reserved word in VB and VBA. Change the name of your variable.

The following syntax works: 
Dim sType As String Dim lig As Long lig = 14 sType = worksheets("Feuil1").Range("L" & lig).Value


;o)

polux
--
“What is well conceived can be clearly stated, And the words to say it come easily.”
Nicolas Boileau
1
Dolichotis Posted messages 42 Registration date   Status Membre Last intervention   3
 
Hi Polux!

Actually, I changed the name of my variable a bit before posting. And wsExcel is a sheet of a workbook (which I declared: 
Set wbExcel = ActiveWorkbook Set wsExcel = wbExcel.Worksheets("alpha")
)
I declared Lig as an Integer but it's a variable that changes value, it is part of a loop. Is Long preferable to Integer? 


Dim sType As String sType = wsExcel.Range("L" & Lig).Value
0