Solved

VB 2005 variable hides a variable in an enclosing block

Posted on 2007-11-14
4
3,266 Views
Last Modified: 2013-11-26
In the following line I get the error
Variable 'rfound' hides a variable in an enclosing block
Dim rFound As Microsoft.Office.Interop.Excel.Range

Not sure what this means
0
Comment
Question by:murbro
  • 2
4 Comments
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
ID: 20279899
Variable '<variablename>' hides a variable in an enclosing block  

A variable enclosed in a block has the same name as another local variable

http://msdn2.microsoft.com/en-us/library/wtk40des(vs.80).aspx
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 20279905
Just rename Dim rFound As Microsoft.Office.Interop.Excel.Range
0
 
LVL 4

Expert Comment

by:tmwest
ID: 20279911
A variable enclosed in a block has the same name as another local variable.

http://msdn2.microsoft.com/en-us/library/wtk40des(vs.80).aspx
0
 
LVL 23

Expert Comment

by:Ashish Patel
ID: 20279912
Why do you want to declare a variable with an enclosing block?
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video discusses moving either the default database or any database to a new volume.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now