i read your code, everything is fine with it..
if you are using some statement like
goto 1:
goto 2:
goto 3:
then you are skipping some statements,but if such is not the case.
your source it´s ok, and should work perfect
regards
Alejandro.
--- In ExcelVBA@yahoogroups.com, "mickey11030" <mickey11030@...> wrote:
>
> To illustrate my puzzle, I've set up a workbook with 2 sheets, named Vegs and Fruit. the Vegs sheet has Beets Corn Spinach in A1, A2 and A3. The Fruit sheet has Apple Banana Cherry in B1, B2 and B3.
>
> I wrote the following code:
>
> Sub Test()
> Dim FruitName As String
> Dim VegName As String
>
> 1 Sheets("Vegs").Select
> 2 VegName = Range("A2")
> 3 Sheets("Fruit").Select
> 4 FruitName = Range("B1")
> 5 VegName = Sheets("Vegs").Range("A2")
> End Sub
>
> I initially displayed the Fruit sheet, and when stm 1 was executed, the Vegs sheet was displayed. But after stm 2 was executed, VegName was empty, i.e., "". That is the first puzzle - VegName should be Corn.
> When stm 3 was executed the Fruit sheet was displayed. When stm 4 was executed FruitName was Apple. That indicates to me that stms 1 and 2, which are similar to stms 3 and 4, should work. To put icing on the puzzle, after stm 5, which is equivalent, I think, to stms 1 and 2, is executed, VegName finally had the value Corn.
> I also noticed when I hover the mouse over Range("A2") in stms 2 or 5 nothing displays, but when I hover the mouse over Range("B1") in stm 4, a tooltip displays Range("B1")="Apple".
>
> What in the world is going on?
> Thanks.
>
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