Solved

VB 2005 variable hides a variable in an enclosing block

Posted on 2007-11-14
4
3,280 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

751 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