Problem with VBA code

Closed

Ruben - Aug 17, 2010 at 06:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:59 PM

Hello

Lets say I want the value of the cell defined by row "Banana" and column "Old".
You can abviously tell it is the value "40", but how do I write that in VBA code?

.......... Fresh Old
Apple.. 10 20
Banana 20 40
Lemon. 30 60

Any help plz ?

Ruben
Norway

Problem with VBA code
Vba find - Guide
Cs 1.6 code - Guide
Vba select case like - Guide
Www.gameloft.com unlock code ✓ - Phones, PDA & GPS Forum
Lava reset code ✓ - Phones, PDA & GPS Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 17, 2010 at 11:59 PM

locate row for banana ( say it is lRow)
locate column for old ( say it is iCol)

then

Cells(lRow, iCol) gives you 40

Similar discussions

lava hard reset & factory reset

Using VBA Code to extract data from a website

Samsung mobiles Nitro racing code

How to code unlock ninja up for intex phone

tetris game unlock code

Similar discussions

Subscribe To Our Newsletter!