hi

There is nowhere in the first macro where you show a call to the
Nth_Occurrence function, when you call it, do you provide all the
arguments?

At a glance, I suspect it may not be working because of the use of
"xlwhole" in the below line of code:

Code:
--------------------
Set rFound = range_look.Find(find_it, rFound, xlValues,
xlWhole)
--------------------

When the macro "GetCallout_Click" is run, does the result get pasted
into the excel sheet differently (eg into a single column) or at least
appear differently than when it is done manually?

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99007