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?

Please Login or Register  to view this content.

**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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

What are you actually trying to do?

How to select activecell

LinkBack

Thread Tools

Rate This Thread

Display

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