Max,

thanks max, works a treat.

One thing that worries me about array formulas is speed. I need to put this
formula in 100 rows on 7 different worksheets. Do you think this will be slow.


"Max" wrote:

Try this, array-entered in say F6, then copied down as required:
=MAX(IF(G5:IV5<"",COLUMN(G5:IV5)))-COLUMN(G5)+1

voila? celebrate it, hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"NDBC" wrote:
.. What I want is the last used column to the right of column G - column G.
The formula is entered in column F. There are blank cells to the left of column F.