Re: Vedr: [ExcelVBA] Find position of first non-zero in range

 

Thanks for your interest, Lisa.
The range is fixed, but I don't want an extra column/row.

Torstein

Den 16. des. 2012 kl. 18:01 skrev 1z@compuserve.com:

> Hmmmmmm,
>
> Best way so far for me is.....
>
> Have an extra row with...
> =IF(C10=0,0,COLUMN()-3)
> autofilled across and then the position you want is
> =MIN(C10:K10)
>
> HTH
> Lisa
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 2

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___