| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
specify a specific column to input text based on another cell's content
I am using a script to search out cells with specified text within a
specific column, once it finds these cells it make several changes, one action is a number needs to be placed in another cell of another column. The cell with the specified content is in column "N" and i need to place a "0" in column "B". i am currently using the line below to do the task: i would like to not rely on an offset and have it find column "B" can anyone help me with this please. cell.Offset(0, -12).Value = "0" God bless jsd219 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro help: moving specific cells based upon content | Excel Worksheet Functions | |||
| how to find and replace content of a specific cell based on its ad | Excel Discussion (Misc queries) | |||
| extract data from a range based on other cell's input | Excel Discussion (Misc queries) | |||
| VLOOKUP based on PART of another cell's text | Excel Discussion (Misc queries) | |||
| Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
Threaded Mode
