How to select activecell

**excel_vb** · 05-02-2010, 12:21 AM

Hi,

Plzzz help...I have the following code in worksheet_selectionchange.
I believe the code-If ActiveCell.Address = "H"&i- does not work.
In column F, I have drop down list with 'Yes' or 'No' as options.
If the user chooses 'Yes' in column F, check if user has skipped column G and moved to column H in which case the mesg pops up saying column G cant be blank. If it is not blank, then do a few vlookups on the next few cells.
What part of my code is faulty?

For i=2 to 10
If Range("K" & i) = "" Or Range("L" & i) = "" Then
If Target.Row = i And Target.Column = 6 Then

If Range("F" & i).Value = "Yes" Then
If ActiveCell.Address = "H" & i
         If Range("G" & i) = "" Then
            MsgBox ("Column G cannot be blank if you choose 'yes'.")
            Range("F" & i).Select
            else
           blah blah
           end if
else If Range("F" & i).Value = "No" Then
         blah blah
        end if
end if
else
end if
else 
end if


next i

**teylyn** · 05-02-2010, 12:43 AM

Hello excel_vb,

maybe you should take a look at what ActiveCell.Address returns. Hop into the Immediate Window and type

debug.print ActiveCell.address

Then study the result.

You'll find that the cell address is returned as $A$1, i.e. with the $ sign.

Thus, your code must include the $ sign as well. Like in this code snippet

Sub what()
Dim i As Integer
i = 1

If ActiveCell.Address = "$A$" & i Then
    MsgBox "This is the active cell"
Else
    MsgBox "this is not the active cell"
End If

End Sub

can you take it from here?

**excel_vb** · 05-02-2010, 01:38 AM

yes, it did.
Thanks Teylyn!

**royUK** · 05-02-2010, 03:17 AM

Presumably you are using a worksheet event, you should post the full code, then Target would be the ActiveCell so how can this ever be true

If Target.Row = i And Target.Column = 6 Then
'etc
If ActiveCell.Address = "H" & i

What are you actually trying to do?

How to select activecell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to select activecell

Re: How to select activecell

[SOLVED] How to select activecell

Re: How to select activecell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions