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 : Récupérer la valeur d'une cellule

3 answers

Jbl 500 bt one-sided issue.

Remove youtube from freebox pop apps

Subliminal image in a video

I'm looking for java or jar game sites.

How to unsubscribe from jm plan cul

Edit ad on leboncoin for free

Commun.file_upload.maxsize

Problem opening modal window from another page

Thursday modification test title number 3

How to change sources on a grundig universal remote?