Auto inserting a text in a cell

rifleforger

New Member
Joined
Aug 1, 2010
Messages
6
Hi guys,

For Each detect In Range("I1", Cells(Rows.Count, "I").End(xlUp))
If detect.Value = "Modem" Then <--Insert "N/A" in Ip add column
Next detect

What I want to happen is that once the word modem is detected I want to automatically insert the "N/A" in another column(Ip address)?

can you guys help me out?

Device Type Ip Address
Modem N/A

Thanks and Regards,
rifle
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
Something like:

Code:
For Each detect In Range("I1", Cells(Rows.Count, "I").End(xlUp))
If detect.Value = "Modem" Then cells(detect.row,"IP") = "N/A"
Next detect
 

rifleforger

New Member
Joined
Aug 1, 2010
Messages
6
Something like:

Code:
For Each detect In Range("I1", Cells(Rows.Count, "I").End(xlUp))
If detect.Value = "Modem" Then cells(detect.row,"IP") = "N/A"
Next detect
I tried it but it work but i get an error

Run-time error '-2147417848 (80010108);
Method '_Default of object 'Range' failed

And after getting the error my spreadsheet just froze. I can't edit anything
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,490
Messages
5,511,645
Members
408,859
Latest member
willm57

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top