If you can use a UDF in your workbook then you could use one like so

Function FullPath() As String
Application.Volatile True
FullPath = ThisWorkbook.FullName
End Function

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"gaftalik" <gaftalik.1ye3na_1131808801.3548@excelforum-nospam.com> wrote in
message news:gaftalik.1ye3na_1131808801.3548@excelforum-nospam.com...
>
> Hi all ,
>
> How can i edit in a cell a formula to retrieve the whole path of the
> sheet and not only the file !
>
> Thank you veru much.
>
>
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile:
> http://www.excelforum.com/member.php...fo&userid=6450
> View this thread: http://www.excelforum.com/showthread...hreadid=484534
>