VBA code to find a cell

[abhishek2301]

Dear All,

I am stuck with a problem!!
I want some help regarding the following situation:
I need to find a cell in the worksheet with a specified string, then go two steps rightwards to another cell and put a specified integer value in that cell.
The search range is actually a date string that can be found in different rows of column A only.
I need to do this entirely in VBA only
Any help regarding this will be highly appreciated!!!

Thanks!!!

[royUK]

Use the VBA Find function. The example in the VBA Help files is straight forward, or search the forum for FIND

[Kenneth Hobson]

Are you sure it is a date string that you are looking for and not the actual date which is a number? Date formats make the numbers appear as strings.

Here is one method. Of course the Find routine is the most efficient.

Please Login or Register  to view this content.

[abhishek2301]

Hi,

I have the following code snippet:

Please Login or Register  to view this content.

Here I am able to get the return value of the FoundCell as "$A$329" which is correct.
Now my goal is to move two cells rightways and then plug a specified integer value in that particular cell.
I need to know how to move two cells rightward so that I can get hold of the target cell.

Your help will be highly appreciated.
Thanks!!

[Leith Ross]

Hello ,

This macro will set the cell 2 columns to the right of the found cell to the integer variable N. This macro format uses late binding. This is typically run from another application other than Excel to manipulate a workbook. If this macro is being run from Excel then the macro should be change for better maintainability and efficiency.

Please Login or Register  to view this content.

Sincerely,
Leith Ross