Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Problems usinga a variable in a worksheet function?


DMoney,

Many thanks indeed! Works like a treat!

Can't believe all these headaches were simply due to the fact that yo
can't, seemingly, use workbook/sheet variable references in worksheet
functions within VBA but, instead, have to use strings. I won't forge
this lesson!

You really have helped me out so many thanks.

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=27626

  #2   Report Post  
Posted to microsoft.public.excel.programming
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

.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Syntax for using a variable in a worksheet function xjetjockey Excel Discussion (Misc queries) 3 January 9th 07 04:23 AM
Problems usinga a variable in a worksheet function? Kobayashi[_53_] Excel Programming 1 November 11th 04 03:42 PM
Problems usinga a variable in a worksheet function? Kobayashi[_52_] Excel Programming 1 November 11th 04 02:30 PM
Problems usinga a variable in a worksheet function? Kobayashi[_51_] Excel Programming 0 November 9th 04 04:43 PM
Problems usinga a variable in a worksheet function? Tom Ogilvy Excel Programming 0 November 9th 04 02:40 AM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"