How to get a value of a cell next to a empty cell

Closed
mike - Apr 15, 2011 at 08:51 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 3, 2011 at 08:22 AM
Hello, all
I have a question how can i create a VBA that will give me the value of a cell in a colum next to a blank cell?
example..below how can i get the return value "hector" by looking up the BLANK.
please advise.



A B C
1 1/3/07 3/3/07 john
2 1/4/07 3/4/07 tom
3 1/5/07 3/5/07 nick
4 1/6/07 3/6/07 tim
5 1/7/07 3/7/07 paul
6 1/8/07 hector








1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 3, 2011 at 08:22 AM
if you know the cell where the blank data is, then you can use offset to get where you want to go
0