VBA: Select a Cell Based on a Value

**iluvfnky** · 03-01-2014, 04:55 PM

Hi,

I am trying to select a cell based on a value as I am creating an offset against it. The cell value I want to select is in Row A and is 21 ROI & NI.

Can anyone help. Thanks..

**ajryan88** · 03-01-2014, 05:36 PM

Hi,

Try:

Please Login or Register  to view this content.

I hope this helps

**TMS** · 03-01-2014, 06:34 PM

Another option:

Please Login or Register  to view this content.

Regards, TMS

**TMS** · 03-02-2014, 03:18 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

**iluvfnky** · 03-02-2014, 07:02 AM

Thanks very much to both..

VBA: Select a Cell Based on a Value

LinkBack

Thread Tools

Rate This Thread

Display

VBA: Select a Cell Based on a Value

Re: VBA: Select a Cell Based on a Value

Re: VBA: Select a Cell Based on a Value

Re: VBA: Select a Cell Based on a Value

Re: VBA: Select a Cell Based on a Value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find cell based on its text value in row 1, then select the cell directly below that

Select sheet based on cell value

Select row based on a cell value...

VBA select cell range based upon the # of rows that make up a certain merged cell?

Macro - Select cell based on cell reference

Bookmarks

Bookmarks

Posting Permissions