Problems usinga a variable in a worksheet function?

K

Kobayashi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems usinga a variable in a worksheet function? 1
Variable not yet created in this context 1
Using the INDIRECT function across multiple worksheets 1
"Subscript out of range" -- using variable as new name of workshee 2
making a worksheet & certain ranges within a variable 3
Identifying the worksheet and cell that contains a function call 3
Public Variable dilemma 23
Global variables - where do you place them? 16

Top