Hi Mark,

Why not post the code of your Sub, so we can see how to transform that into
a Function?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"CuriousMark" <CuriousMark@discussions.microsoft.com> wrote in message
news:148D9FEA-4FFA-4E54-B998-0E2BC401ECA9@microsoft.com...
>I have a spreadsheet with a very long hex string containing data stored on
>a
> big endian computer (or is it little, doesn't matter it's reversed) and
> the
> byte order is reversed. I have a VBA sub that takes a string as input and
> returns a reverse byte ordered string as a result. That is simple and
> straightforward. Now the hard part, how do I call that sub in the
> spreadsheet as if it were a function? I find help information on how to
> use
> spreadsheet functions in VBA, but not the other way around. I should
> point
> out this is my first VBA usage (office 2003) that wasn't just a
> modification
> of a recorded macro. So I expect the answer will be basic and obvious
> (once
> you know it).
> Thanks in advance for your help,
> Mark