Prev: help to reduce size of my file
Next: VBA command to move cursor
From: KenG on 28 Mar 2010 06:30
After defining a new Name ("_year") in my worksheet, I find that my makro
code (Private Sub cmdNewEntry744_Click()
With NewEntries
..Show
End With
End Sub)
can no longer open my dialog box. I get a runtime error 1004 a message
refering to VLookup property of Workbook function class.
The name "_year" refers to "=If(month="JAN.";R[-1]C + 1; R[-1]C)".

WhatIdo??

KenG
From: Joe User on 28 Mar 2010 06:41
"KenG" <KenG(a)discussions.microsoft.com> wrote:
> After defining a new Name ("_year") in my worksheet,
[....]
> I get a runtime error 1004 a message refering to VLookup
> property of Workbook function class.
> The name "_year" refers to "=If(month="JAN.";R[-1]C + 1; R[-1]C)".

I presume you mean WorksheetFunction.VLookup.

It is unclear exactly how you are trying to refer to the Excel defined name.
You should show us a code snippet.

But in any case, I can imagine that WorksheetFunction.VLookup cannot
reference an Excel defined name.

I would use the Evaluate function. I cannot be more specific because you
were not more specific.


----- original message -----

"KenG" <KenG(a)discussions.microsoft.com> wrote in message
news:11E1C6A7-B3D9-4DAA-A462-163FACAB6B58(a)microsoft.com...
> After defining a new Name ("_year") in my worksheet, I find that my makro
> code (Private Sub cmdNewEntry744_Click()
> With NewEntries
> .Show
> End With
> End Sub)
> can no longer open my dialog box. I get a runtime error 1004 a message
> refering to VLookup property of Workbook function class.
> The name "_year" refers to "=If(month="JAN.";R[-1]C + 1; R[-1]C)".
>
> WhatIdo??
>
> KenG

From: Don Guillett on 28 Mar 2010 08:24
As ALWAYS, post YOUR code for comments.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"KenG" <KenG(a)discussions.microsoft.com> wrote in message
news:11E1C6A7-B3D9-4DAA-A462-163FACAB6B58(a)microsoft.com...
> After defining a new Name ("_year") in my worksheet, I find that my makro
> code (Private Sub cmdNewEntry744_Click()
> With NewEntries
> .Show
> End With
> End Sub)
> can no longer open my dialog box. I get a runtime error 1004 a message
> refering to VLookup property of Workbook function class.
> The name "_year" refers to "=If(month="JAN.";R[-1]C + 1; R[-1]C)".
>
> WhatIdo??
>
> KenG

 | 
Pages: 1
Prev: help to reduce size of my file
Next: VBA command to move cursor