View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dmoney Dmoney is offline
external usenet poster
 
Posts: 42
Default Problems usinga a variable in a worksheet function?

Glad I could help

-----Original Message-----

DMoney,

Many thanks indeed! Works like a treat!

Can't believe all these headaches were simply due to the

fact that you
can't, seemingly, use workbook/sheet variable references

in worksheets
functions within VBA but, instead, have to use strings. I

won't forget
this lesson!

You really have helped me out so many thanks.

Adrian


--
Kobayashi
----------------------------------------------------------

--------------
Kobayashi's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=871
View this thread:

http://www.excelforum.com/showthread...hreadid=276260

.