ARGGHH! Typo time. The function call should be:

=ShtComment(A3)

Regarding splitting the formula across cells in 2 columns: once you are
satisfied you are getting the expected results, you could hide the column
with the second cell.

"Tom Hutchins" wrote:


You need to copy the function into a VBA code module (not a sheet or
ThisWorkbook module) for it to be visible to Excel.

It takes a single cell as an argument:
=Sht(Comment(A3)
if called from A3.

But, why would you call it from A3? You are testing A3 in the function to
see if it is empty. If it has a formula, it is not empty.

Regards,

Hutch

"gardenhead" wrote:

First off, thanks for the reply.

I'm trying your function out but I don't think I'm using it correctly.
It wasn't clear to me if I should have something as it's input. In cell
G3 I tried "=ShtComment", "=ShtComment()" and "=Sht(Comment(A3)" and a
bunch of other cell ranges and they all gave me a #NAME error.

The first suggestion is definitely doable (and I will be using that if
the above doesn't work out) but it'd be nice to not have to enter
another column as the spreadsheet's already 36 columns wide :D