Ahh. Good catch Derek.
The top part needs to be changed:
Function CalcOff(Condition, Optional WorksheetNameParameter As String)
and the For statement:
For Each ws In Worksheets
If Worksheets(WorksheetNameParameter) = ws.Name Then
WorksheetFound = True
Exit For
Tim
-----Original Message-----
From: "Derek Turner" <g4swy@yahoo.com>
Sent: Monday, March 31, 2014 12:14pm
To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
Subject: Re: [ExcelVBA] VBA EnableCalculation Clean Up
The optional parameter should be a String. Test.
Derek Turner +++
>________________________________
> From: "rajarjrtj@yahoo.com" <rajarjrtj@yahoo.com>
>To: ExcelVBA@yahoogroups.com
>Sent: Monday, 31 March 2014, 17:48
>Subject: RE: [ExcelVBA] VBA EnableCalculation Clean Up
>
>
>
>
>twlewis64, thank you for taking the time to correct my rudimentary VBA code, what you provided is way beyond my capabilities, but your notes did allow me to follow the modified VBA code.
>
>I'm no sure what I'm missing, but I cannot get any function inputs to work, and VALUE! is the only function return. Could you please provide an example of the proper syntax for the function input?
>
>Thanks again!
>
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar