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

Closed
mike - Apr 15, 2011 at 08:51 PM
rizvisa1 Posts 4478 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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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