what is mround?

[sallyt]

Can anyone help with with mround? Got in some old
spreadsheets but can't see what it does? Thanks.

Second question .... is there a way to automatically get
the full file name and PATH in the header or footer in
Excel????? Not just file and sheet name, but path? Know I
can do it in a CELL, but want in a header or footer. Ta
Sall

 

[Don Guillett]

F1 >index>mround

 

[J.E. McGimpsey]

Look at XL Help:

MROUND

Returns a number rounded to the desired multiple.
If this function is not available, run the Value Pack Installer to install
the Analysis ToolPak. After you install the Analysis ToolPak, you must enable
it by using the Add-Ins command on the Tools menu.
...

 

[J.E. McGimpsey]

For WinXL versions prior to XL02 and all MacXL Versions:

Put this in the ThisWorkbook code module (right-click on the
workbook title bar, choose View Code, paste the following in the
window that opens, then click the XL icon on the toolbar to return
to XL)

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet

For Each wkSht In ActiveWindow.SelectedSheets
wkSht.PageSetup.LeftFooter = ActiveWorkbook.FullName
Next wkSht
End Sub

You can substitute CenterFooter or RightFooter for LeftFooter.