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

I accidentally liked a photo on instagram.

Delivery address track718

Dymo letratag ribbon blockage

Mouse wheel that changes the sound???

My google chrome homepage is shifted to the right.

Notice shows wr30 m

Keyboard locked: what to do?

[grouped subject] review of vova: is this site reliable?

Asus: my battery won't charge anymore.

How to know if the floryday shopping site is really reliable?