This is probably a very simple formula but I'm having trouble with a search part.
I would like to offset the cells in a particular column "D" which have the term "USA" in them one cell to the right.
Not all the cells in this column contain this term and I don't want any other columns affected.
With what I have searched for so far it will start with something like
ActiveSheet.Range("D")
And the last part of the formula will most be:
Selection.Offset(0, 1)
Thanks for the help.
Do you mean that if you found USA in, say D2, you want D2 to become E2? Offset is simply a way to navigate, so by saying that you want to offset one cell to right, you are really asking to move the active cell one cell to the right. Is this what you meant?
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
That is exactly what I mean.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks