Hi Kevin,

Can you post the text of the whole subroutine or function? That would give
us more to work with.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Kevin Lyons wrote:
Jake,

Thanks for the quick reply!

My variables are declared as follows:

Dim test1, test2, topRange, ceilName, floorName, diffName As Long,
fullRange, startRange, finishRange, actName As Long, menu, menuItem,
borRow, eorRow, i, counter, helpmenu As CommandBarControl, newMenu As
CommandBarPopup, Macros_menu_found As Boolean

I originally had diffName and actName without the "As Long", but then
I was receiving "Data Type Mismatch" errors in the same code.

After adding "As Long" that error disappeared. I had tried "As
Double" for both, but the "Data Type Mismatch" error persists!

Any ideas as to what I can do?

Thanks,

Kevin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!