View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Beau Black Beau Black is offline
external usenet poster
 
Posts: 1
Default How do i find the last entry in a column where every cell is not .

I have an excel worksheet that keeps track of our gas inventory. We get gas
delivered once a week and when its delivered we post the price. I wind up
with a column that has prices and non entries. Month End i need the LAST
price we were charged to produce a report. It would be nice if Visual Basic
had a function called Last but alas I have not found it. I have to do a lot
of gyrations to get this data. Does someone know an easy way to get this data.