vba string problems

[excel_lint]

When I run this subroutine:

Sub test_macro()
String1 = "Hello World"
String2 = Right(String1, 3)

End

I get this compile error message:
"Can't find project or library"
It shows the line:
String2 = Right(String1, 3)
with "Right" in bold.

I know this is something very simple but I'm unable to figure it out.

 

[eliW]

On 2002-04-03 12:49, excel_lint wrote:
When I run this subroutine:

Sub test_macro()
String1 = "Hello World"
String2 = Right(String1, 3)

End

I get this compile error message:
"Can't find project or library"
It shows the line:
String2 = Right(String1, 3)
with "Right" in bold.

I know this is something very simple but I'm unable to figure it out.

I've copied your macro to my worksheet and it works fine. Try to do the same in another workbook.
End with 'End Sub'
Eli
This message was edited by eliW on 2002-04-03 14:36

 

[Dave Hawley]

Hi excel_lint

While in the VBE go to Tools>Refrences the missing reference will be preceded with the word "Missing" use the browse button to locate and load it.

 

[excel_lint]

Thanks, I opened a new worksheet and it worked fine. Don't know why it won't work in the orginal but this solution will get me going.
--------------
On 2002-04-03 14:35, eliW wrote:

On 2002-04-03 12:49, excel_lint wrote:
When I run this subroutine:

Sub test_macro()
String1 = "Hello World"
String2 = Right(String1, 3)

End

I get this compile error message:
"Can't find project or library"
It shows the line:
String2 = Right(String1, 3)
with "Right" in bold.

I know this is something very simple but I'm unable to figure it out.

I've copied your macro to my worksheet and it works fine. Try to do the same in another workbook.
End with 'End Sub'
Eli
This message was edited by eliW on 2002-04-03 14:36
[/quote]

 

[Legacy 98055]

If you do not see a missing reference, change your code as follows:

String2 = Right(String1, 3)
String2 = Strings.Right(String1, 3)

That should solve your problem

Tom