Excel VBA: Retrieve the value of a cell. Solved

Question

Hello,
I just want to know how to retrieve the value of a cell
To get the address:
Cell.address
The row:
Row.row
The value: (the word contained in the cell in Excel)
?Configuration: Windows XP
Firefox 3.0.6

lermite222 · Accepted Answer

Hello,
One way to do it...

Result = Cells(Row,Column).Value

another way

Result = Range("A1").value

See you later
Experience teaches more surely than advice. (André Gide)
If you bump into a pot and it sounds hollow, it doesn't necessarily mean the pot is empty. ;-)(Confucius)

la pioche · Answer

Thank you

I just succeeded, however my program doesn't work, can you take a look at it
I simply want to create a loop
and when it hits a non-empty cell, it retrieves the value of that cell and writes something on a sheet with the same name as the cell
for example, cell "chaussée" opens the sheet "chaussée"

Sub essai() Dim Cellule As Variant Dim ok As Variant For Each Cellule In Range("ListeDéroulante") Do While Cellule <> "" ok = Cellule Worksheets("ok").Range [A1] = "yes" Loop Next End Sub

mikebzh · Answer

 Dim Cell As Range Dim sheetName As String For Each Cell In Range("DropdownList") If Cell.Value <> "" Then sheetName = Cell.Value Worksheets(sheetName).Range("A1") = "yes" End If Next

A little advice, use variables with coherent names, even in the smallest piece of code, you'll see that it greatly simplifies reading.
Good luck

Excel VBA: Retrieve the value of a cell.

3 answers

Your smartphone, an overlooked universal remote

Second screen resolution inaccessible

Fb account without administrator access

Phone battery life

Texture issues in enshrouded

How to turn on a kobo e-reader

Pin code (windows hello)

Many f a i offer a €2 subscription and the card €1"

Is my home wi-fi network not the same as my box? is that normal?

Incompatible display driver