Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
wal wal is offline
external usenet poster
 
Posts: 19
Default Unable to get the VLookup property - worksheet.function error

Thanks. This is helpful. I'll try your refinements.

Although I didn't ask about it the first time around, I'm still
confused about what the volatile line is supposed to do when it's true
vs. when it's false. (The Help file is kind of cryptic.)

On my sheet, I've tried it both ways. True seems better. I'd prefer
the function (deadline dates) to recalculate when I alter the dates in
the HolidayList, and true causes that to happen. (It doesn't matter
that much, because the worksheet is intended to provide a quick
calculation of ad hoc deadline dates for the user; the data cells will
clear upon close.)

Sometimes, whether volatile is set to true or false, a #Value! error
appears in the result (deadline) cell, and F9 doesn't resolve it. I
have to enter fresh (or the same) data manually to force a
recalculation.

Thanks again.
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
Run-Time error '1004: Unable to get the PivotTables property of the worksheet class magarnagle Excel Programming 4 May 19th 06 11:20 AM
Run time error 1004 - unable to get the chartObjects property of the worksheet class hedgehog1 Excel Programming 1 April 10th 06 08:10 PM
Runtime error 1004 - unable to set Visible property of Worksheet c SueJB Excel Programming 2 October 4th 05 02:27 PM
Error: Unable to get the OLEObjects property of the worksheet class Grant Excel Programming 2 August 6th 04 02:20 PM
Run-time error '1004' - Unable to set the Visible property of the Worksheet class Shalin Chopra Excel Programming 3 November 25th 03 08:38 PM


All times are GMT +1. The time now is 04:14 AM.

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

About Us

"It's about Microsoft Excel"