Previous Topic Next Topic

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



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
0

Similar discussions

Unlock code
Priya -
HelpiOS -

1 response
lava hard reset & factory reset
AVAY -
Pnr -

2 responses
Can't log in to Facebook because Code Generator fails
Basp343 -
HelpiOS -

46 responses