Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

FINDING LAST CELL AND VALUE IN A COLUMN

  Asked By: AMANKWAH    Date: Feb 26    Category: MS Office    Views: 5362
  

please I have a range of values in a column. the range is now B1:B49. These values changes and may sometimes increase to B55 or even B65. the range is not stable. I want to write or record a macro which will identify the last value down the column range, be it any cell in the column and if the value in that last cell down the column is more than 60, then YES, Between 60 and 40=undecided and if below 40, then NO. please I need help.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on FINDING LAST CELL AND VALUE IN A COLUMN Or get search suggestion and latest updates.




Tagged: