LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Display first cell in the right of range

Hi.
Without VBA code, I need to fill in B10 the last cell present in the
range A1:A10 (but not always the cell on the left in range A are fill,
so I cannot use index based on "full cells" minus "empty cells").
I mean that in B10 must be the first fill cell startng from right of
the range A1:A10

ex.
a) If I put in A3 = 445, in A5 = 99 the B10 must have 99
b) If I put in A6 = 45, in A9 = 9 the B10 must have 9
c) If I put in A2 = 45, in A4 = 444, in A9 = 9 the B10 must have
d) If I put in A2 = 45, in A4 = 444, in A9 = 333 the B10 must have 333

Thanks in advance
M.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If cell not empty, then display from range puiuluipui Excel Discussion (Misc queries) 7 October 3rd 09 08:01 PM
find last cell in range with data, display cell address sevi61 Excel Worksheet Functions 14 October 29th 07 08:36 PM
Want to add value from a range and display result in a cell. michaeltiang Excel Worksheet Functions 3 August 8th 07 01:38 PM
Display cell value in a range saman110 via OfficeKB.com Excel Discussion (Misc queries) 4 August 6th 07 11:21 PM
Comparing a cell value to a range value and display a matched value Albert Sim Excel Programming 0 January 27th 04 04:26 AM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"